Home Forums SQL Server 2005 T-SQL (SS2K5) Disabling index by using select query RE: Disabling index by using select query
scott.pletcher
SSCertifiable
Points: 5958
More actions
September 7, 2010 at 3:37 pm
#1217650
There'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).
Scott Pletcher, SQL Server MVP 2008-2010