Topic: How temporarily to ask the optimizer not to use this or that index?
There is large 24/7 OLTP a system. On a problem to the table a heap of indexes.
Thus all indexes are used in different (but anywhere is not present an index INDEX).
It is required to look at that as the system leads if any index "was not".
Thus to delete an index it is impossible. To disconnect an index too it is impossible that is equivalent DROP but with saving of meta data about .
It is actually necessary globally to forbid for the optimizer to use a certain index.
The reason of such perversions that index re-creation extremely strongly strikes on performance.
I appeal to great experts.
Who helps helps or at least on clever thought pushes?
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) A Developer Edition (64-bit)