Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Right index but not taken
Message
 
 
À
15/01/2014 14:23:51
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01591957
Message ID:
01591961
Vues:
33
>>Did you try to recompile it? E.g. is it a stored procedure or just a statement? If the latter, try playing with the options OPTION (RECOMPILE) or OPTIMIZE FOR UNKNOWN
>
>I added that to the command and clicked on Display execution plan. It is still the same thing.

You can force usage of a specific index, but normally it's not a recommended approach. Is the query very complex?

Are you running in development environment where you can afford to get rid of all plans?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform