Re: Oracle 8 partitionning

Are you taking full advantage of the parallel query option which can allow
for parallel_index access to the data when multiple partitions are required ?

It has the side-effect (at present) of causing a global checkpoint whenever a
parallel query hits multiple partitions of partition table, but the performance
can still be dramatic.

Bert Scalzo <bscalz01_at_7-11.com> wrote in article <6a7ikg$rk8$1_at_news.ses.cio.eds.com>...
> I am testing oracle 8 partitioning on a large data warehouse. My
 findings
> are not good. We have a third party OLAP tool that generates all
 the of our
> users queries. The problem is that for partitioning to yield good
 results,
> the OLAP generated where clause must reference the partition key in
 order to
> do partition elimination. If the partition key is not in the where
 clause,
> then you do full partition operations (e.g. range scan of indexes

• but for
  > all partitions, not just the ones of key interest).
  >