Re: Simple SELECT taking long time...

Bandoba,

Yes, that is kind of slow. I ran a query on a 40 column wide table, sorted on 3 columns and limited the result set to 60000 rows in 16 seconds. This was on a slow NT4 box with known serious fragmentation at both the OS and tablespace level. I know my faster NT boxes are 5-10 times faster than what I just tested on.

There are a lot of things that might help.

1. More free RAM
2. More Disk space
3. Defragment the disk volume
4. Defragment the tablespace
5. Add Indexes
6. Fewer users/services on the server
7. Adjust SGA settings,
8. Faster Network hubs,...

Rock.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!