Use FULL hint to optimizer for full table scan

Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another.

Use an expression in the Where Clause of the SQL.

Disable Index on the column