Re: Speed up "order by"
From: <Manisha>
Date: 1995/10/11
Message-ID: <45fdhb$smg_at_data.interserv.net>#1/1
Date: 1995/10/11
Message-ID: <45fdhb$smg_at_data.interserv.net>#1/1
Check out the storage parameters of your TEMPORARY SEGMENT. Increasing the size of your cache (if possible) might also help.
Manisha Handa
> >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?
Received on Wed Oct 11 1995 - 00:00:00 CET