Joy Of Crystal

SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

March 10, 2010 on 7:30 pm | In SQL Authority |

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan?

More here: 
SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint