Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9iR2 partitionned table
Sylvestre wrote:
> 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
Current statistics and patching to 9.2.0.8 would both be worthy of consideration.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Apr 23 2007 - 16:49:58 CDT