prakash.kumar3669 (1/17/2013)
What i have read from online articles, its important to index the columns which comes in where condition.
Not only Where BUT group by, order by , JOIN's ON clause , Partititon by , and also the SELECT's columns.
See this http://www.sqlservercentral.com/articles/Indexing/68439/
prakash.kumar3669 (1/17/2013)
if i have 5 columns to retrieve in my queries then what's the best way of indexing ?
then those columns should be part of Covering index INCLUDE's part.
For better solution.post that Query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)