Re: Speed up "order by"
From: John Leon Guerrero <jlg_at_walker.com>
Date: 1995/10/12
Message-ID: <45i4d0$mq8_at_noc.usfca.edu>#1/1
Date: 1995/10/12
Message-ID: <45i4d0$mq8_at_noc.usfca.edu>#1/1
>> >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?
To the original poster: I assume you've tried putting an index on the order by fields--correct?
jlg_at_walker.com Received on Thu Oct 12 1995 - 00:00:00 CET