Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Right index but not taken
Message
 
 
To
15/01/2014 14:23:51
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01591957
Message ID:
01591961
Views:
30
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform