Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 9iR2 partitionned table

Re: 9iR2 partitionned table

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 24 Apr 2007 11:45:22 -0700
Message-ID: <1177440321.978817.81790@t38g2000prd.googlegroups.com>


On Apr 23, 4:25 pm, "Sylvestre" <Sylves..._at_world.com> 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

Would be useful if could post a trace of your statement (including bind variables if you use them). Received on Tue Apr 24 2007 - 13:45:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US