How to ignore index hints in SQLSERVER
Today, I will talk to you about how to ignore index hints in SQLSERVER, many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.
When we want a query to take advantage of an index, we usually add an index hint to the query, like this
The copy code is as follows: SELECT id,name from TB with (index (IX_xttrace_bal)) where bal
