Search My Oracle Blog

Custom Search

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.
Posted by Hemant K Chitale at 11:17:00 PM

2 comments:

Parag said...

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

--- Parag Sathe

21 March, 2008 10:23
Hemant K Chitale said...

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

21 March, 2008 22:54

Post a Comment

Subscribe to: Post Comments (Atom)

Aggregated by orafaq.com

Aggregated by orafaq.com
This blog is being aggregated by orafaq.com