• 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