SQL SERVER Force Index Scan on Table Use No Index to Retrieve the Data Query Hint
Posted
on Dot net Slackers
See other posts from Dot net Slackers
Published on Thu, 11 Mar 2010 00:00:00 GMT
Indexed on
2010/03/11
5:48 UTC
Read the original article
Hit count: 490
Filed under:
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 [...]...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
© Dot net Slackers or respective owner
