09 February, 2008

Indexing NULLs -- Update

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:

Parag_Sathe said...

Yes, But we can solve this problem , by creating a function based index esp. using NVL() function.

--- Parag Sathe

Hemant K Chitale said...

Can you provide a worked example (table, index, query and execution plan / trace) ?