Indexing Null Values – Part 2

(Randolf Geist) In the previous post I’ve demonstrated that Oracle has some problems to make efficient use of B*Tree indexes if an IS NULL condition is followed by IN / OR predicates also covered by the same index – the predicates following are not used to navigate the index structure efficiently bu

Register to Read