9iR2 partitionned table

Hello

We have a table with a list partitionning, some partition are empty, when a request use a value of the partitioning key for wich the partition is empty we get a full table scan, even we have an index on the key, why ?

In the same request there are some predicate with constant value, like "OR 'A' in 'A'", when commented, the right index is used, when not we get a full table scan, is this a bug ?, I believed that oracle eliminate the constant predicate evaluation ? (we are in 9.2.0.6).

Thank you Received on Mon Apr 23 2007 - 15:25:29 CDT