chandrasekaran.ganapathy (4/8/2010)
Hi Kingston and all,Got it. I have read some article. So If i make a query like
Select * from employeeId where employeeId between 'xxxxxx' and 'xxxx'
or
Select * from employeeId where employeeId > 'xxxxx'.
These kind of query will be fetched from the database too fast using index.
Please correct me if i am wrong.
Depends. If the optimizer thinks that using the index will be a faster method to fetch the required data it will use your index and fetch the data. But if it decides otherwise, it will not use your index.
And did you download the book from the link provided by GSquared? I don't think you did and if you did you haven't read it. It is a free download and it will have answers to most of your questions.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/