Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Right index but not taken
Message
De
15/01/2014 14:19:50
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Titre:
Right index but not taken
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01591957
Message ID:
01591957
Vues:
65
I have an index on all tables with the primary key, which is clustered. That index is the default one and does not have any other field combined nor any included fields.

I just created a new index on the primary key with the inclusion of two fields to satisfy the optimization of one particular SQL select command. To my surprise, the execution plan does not pick it up. The execution plan still takes the main primary key index.

How can I avoid that situation?
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform