Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too slow query
Message
From
03/06/2001 09:05:16
 
 
To
02/06/2001 18:06:45
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00514252
Message ID:
00514308
Views:
11
13000 rows is a pretty small table. Use DBCC SHOWCONTIG to see if the clustered index is fragmented.

Also, do you really want to bring over the entire table? How large are the rows? Here's a test. Do a SELECT COUNT(*) FROM table will generate the same amount of work as SELECT * FROM table as long as you don't have a non-clustered index on the table.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform