InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 20:26:17 GMT20http://www.sqlservercentral.com/Forums/Topic981481-338-1.aspxif the query has a WHERE statement, you could make the arguments non-SARG-able, and force it to use a table scan, but it would still use an index(probably the clustered index) to gather the data;if you want to avoid a specific index you can use a hint to tell it a specific index to use instead.Tue, 07 Sep 2010 16:18:50 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic981481-338-1.aspxThere's not any hint to disable / ignore an index just for a given SELECT statement (you could force it to use a different index, but even that might not prevent use of the other index also).Tue, 07 Sep 2010 15:37:02 GMTscott.pletcherhttp://www.sqlservercentral.com/Forums/Topic981481-338-1.aspxYou can use ALTER INDEX for a nonclustered index to disable it. If you do this for a clustered index, it makes the data inaccessible.[code="sql"]ALTER INDEX myIndexName ON myTable DISABLE[/code]Tue, 07 Sep 2010 06:27:41 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic981481-338-1.aspxHi all,Is there any way to disable an index by using select query.ThankqTue, 07 Sep 2010 05:53:53 GMTDBA_1276