Why index doesnt access null values? | Exploring Business Intelligence

Why index doesnt access null values?

Posted on July 17th, 2007 biexplorer No comments

Oracle indexes do not contain entries that point to rows with null values on all the indexed columns.

Therefore any query that has a column IS NULL or IS NOT NULL will not use the index.

Database, Oracle Database, Oracle

Leave a reply
You must be logged in to post a comment.