Re: cross-partition query performance

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 08 Jul 1998 20:20:16 GMT
Message-ID: <01bdaaad$53da4700$0300a8c0@WORKSTATION>

Do you get any clues from the partition_start/partition_stop information in the plan_table ?

Also, from your description of the table, the query should be resolved by a count on the bitmap index without going to the partitions themselves. is there more information you can give us.

One possibility: on the single partition you might be getting better balancing across lots of query slaves, whereas with the multiple partition you get restricted to one PQ slave per partition.

Jonathan Lewis Received on Wed Jul 08 1998 - 15:20:16 CDT