Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question on statistics
Message
De
14/03/2008 11:44:12
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01302040
Message ID:
01302162
Vues:
7
>SQL Server would create statistics for columns that don't have indexes if the query optimizer decides that it may speed up queries. It may also indicate that index on such column may be beneficial. It's better to let the SQL Server optimizer create statistics to improve quieries performance.

That's what I believed. So, basically, I should take a look at those and create the proper indexes where needed.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform