Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Too slow query
Message
De
03/06/2001 09:05:16
 
 
À
02/06/2001 18:06:45
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
00514252
Message ID:
00514308
Vues:
12
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform