Re: Oracle V7.3 vs. V8.0

Uday Bikkasani <udayb_at_mindspring.com> wrote in article <6closa$tl6_at_camel18.mindspring.com>...

> Oracle 8 does partition elimination only if you are
 searching based
> on a prefixed local index ( Prefix being the partition key).

This is definitely wrong (or perhaps just incomplete). Oracle does partition elimination when the WHERE clause involves the partitioning columns in a comparison with a literal constant even if the partitioning columns are not the leading columns of an index.

Elimination in most cases is against the boundary conditions on the partitions as stored in tabpart$- but there are some cases where Oracle can infer which partitions to eliminate from non-literal comparisons in join conditions on partitioning columns. Received on Sun Feb 22 1998 - 00:00:00 CST