Hello
Yes statitics are up to date
"Valentin Minzatu" <valentinminzatu_at_yahoo.com> a écrit dans le message de
news: 1177362816.002982.75490_at_b58g2000hsg.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
>
> Are the statistics up to date on those partitions?
>
> Valentin
>
Received on Tue Apr 24 2007 - 12:00:35 CDT