Re: wierd performance problem
Date: Thu, 10 Jul 2008 13:32:51 -0500
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 WilliamsReceived on Thu Jul 10 2008 - 13:32:51 CDT