I've updated my entry on how to index NULLs "
NULLs are not Indexed, Right ? NOT !" because Oracle has published Note#551754.1 titled "Query with ROWNUM Condition on a Table Which Has Index on Column "Constant" Returns No Rows", following Bug#6737251.
2 comments:
Yes, But we can solve this problem , by creating a function based index esp. using NVL() function.
--- Parag Sathe
Can you provide a worked example (table, index, query and execution plan / trace) ?
Post a Comment