Re: rage partitioning; engine not picking up partition

>It is my understanding that Oracle should pick up the correct
>partition even without any kind of index (local or global) and that
>partitioning is mostly helpful when doing full table scans such as in
>this operation. The plan shows a full scan but no partition selection
>and basically the operation takes the same amount of time as an
>identical non partitioned table. I've even enabled parallelism on the
>table and in the session, still no luck. Am I missing something here?
>

IIRC, I don't believe this to be correct. Oracle has something in 8+ called partitoned. For it to scan the proper partition you must have a partioning index on the appropriate key.

If you create an index and then analyze the table and check the explain plan then you should be able to get the proper partition. Otherwise, you can tell the query which partition to look in manually. Received on Sun Jan 26 2003 - 16:24:07 CST