Speed up "order by"

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