When selecting all rows and columns from a table, takes too much time

[Guest_imported]

I have a table with 1200 rows. Total size of a single row is around 1000 characters. When I execute a select * from tablename query in Query analyser, it takes 30 seconds to return the entire rows. I had created a primary key to improve the perofmance. Then I tried clustered and non-clustered indexes also. There is no difference..? Anybody have any Idea??? I'm using SQL Server7.0.

 

[tlbroadbent]

There are a number of factors that can impact performance. Are you searching for specific records or simply returning all records? Are you summarizing or sorting the records? Indexes won't do any good if you simply select all the columns of all the records. They help when you have WHERE criteria, JOINS, ORDER BY or GROUP BY clauses.

What kind of server do you have? Does it have sufficient memory and processor power? What kind of disk I/O does the server have? Is the disk I/O fast enough? How busy is the server? What kind of network do you have? How fast are the network connections? Are you encountering a blocking situation?

Have you monitored server performance - looking at processor usage, number of connections, cache hit ratio, etc? Have you modified the query options to show I/O and time statistics?

Check

http://www.sql-server-performance.com/default.asp

for lots of SQL Server performance tuning help. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.