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