Re: wierd performance problem

Dear DBA,

Perhaps the key is that your table is partitioned, but you haven't given
Oracle to perform partition pruning. Is it trying to retrieve rows from each
partition, then assemble the result? Maybe you could post the explain plan
output?

Dennis Williams

Other related posts: