Rob Reid-246754 (11/27/2012)
whether the optimiser can decide for itself that too many clauses have been used and ignore the extra ones.
sql optimizer defintely choose only that index which is covering the most of the columns (which includes select + where + group by + order by columns ) and further more which index is less resource intensive too.
Rob Reid-246754 (11/27/2012)
Therefore by passing in courseID and RaceType would that help narrow down the results quicker before having to resort to the racename index OR should I just choose the quickest route even if it means using the biggest index to get there.
sql optimizer will choose the index not you (even if your not using any index HINT then) and for this if your post query + index definition then you can get more help.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)