Re: Speed up "order by"
From: Dale E. Benjamin <dbenjamin_at_fcpa.fujitsu.com>
Date: 1995/10/09
Message-ID: <45cc3e$hcv_at_fujitsui.fujitsu.com>#1/1
Date: 1995/10/09
Message-ID: <45cc3e$hcv_at_fujitsui.fujitsu.com>#1/1
You might want to use "explain plan" with and without the order by clause. If your query is multi-table, it may be executing a different plan when the order by is included (or maybe not).
- dale benjamin Fujitsu Computer Products of America
rz86988_at_mcvax2.d48.lilly.com wrote:
>Does anybody know how to speed up the "order by" clause?
>
>The select statement retrieves about 50,000 records and it runs OK, however
>when I add the "order by", it runs over 10 minutes.
>
>What I can do to improve this other than changing the Sort_area_size?
>
>Thanks for any information!
>
>Di Wang
>diw_at_lilly.com
Received on Mon Oct 09 1995 - 00:00:00 CET