Re: Tuning a large order by clause

From: Ronald <devnull_at_ronr.nl>
Date: 14 Nov 2001 05:53:51 -0800
Message-ID: <67ce88e7.0111140553.6d337ea8@posting.google.com>

jwilliam_at_aglresources.com (James A. Williams) wrote in message news:<5003a2b9.0111131147.853a06e_at_posting.google.com>...
> The below query builds an aggregate table. The below order by causes a
> massive scan. I tried a composite index over the order by. I removed
> everything on the order by except for the account_id which has a
> single e-mail. I get a subsecond response.
>
> Can such an order by be tuned. Its traversing a million rows so the
> tempfiles are being hit.

You could try to reduce tempfile usage by using PQ. Every process has it's own sort_area.

Ronald.

---

http://ronr.nl/unix-dba
Ben je een ervaren dba en wil je dat wel eens ergens anders laten zien, mail me dan. Received on Wed Nov 14 2001 - 07:53:51 CST