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

added by pinaldave
3/18/2010 8:15:00 AM


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?