Sorting
From: Scott Metro <smetro_at_world.std.com>
Date: 1997/04/19
Message-ID: <01bc4cc3$34c09020$01c8a8c0_at_smetro1>#1/1
Date: 1997/04/19
Message-ID: <01bc4cc3$34c09020$01c8a8c0_at_smetro1>#1/1
[Quoted] I have a rather large table that, when I use an ORDER BY in a SELECT statement, takes forever to return data. If I take the ORDER BY out of the SQL statement, the data is returned very quickly.
Users' temporary tablespaces are pointing to the correct tablespace (TEMP_DATA). Does anyone know how I can get more speed out of ORDER BY queries? Do I need to bump up the temporary tablespace or is there a way to devote more memory to the sorting functionality?
The server is a 4 Pentium Pro 200 with LOTS of disk space and 256MB of RAM, all running on NT 4 (RAID 5).
Thanks,
Scott Metro
smetro_at_world.std.com.nosmurf
***(take the .nosmurf off the end to reply!)***
Received on Sat Apr 19 1997 - 00:00:00 CEST