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.

2 comments:

Parag 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) ?

Aggregated by orafaq.com

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

Top 50 Oracle SQL Blogs 2016

Top 50 Oracle SQL Blogs 2016
Top 50 Oracle SQL Blogs 2016