Re: Speed up "order by"

In article <1995Oct9.145125.1_at_mcvax2.d48.lilly.com>, rz86988_at_mcvax2.d48.lilly.com writes:
|> 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

This can be done by creating index on the columns used in 'order by' clause. Note that Oracle will use the index in ordered select only if the columns definded as not null.

---
Alexander Lukyanov
lav_at_video.yars.free.net