Hi, Here are some more referrence which will clear your doubt on why and how order or columns determine which index to use, suggest to refer http://searchsqlserver.techtarget.com/qna/0,289202,sid87_gci1166243,00.html http://searchsqlserver.techtarget.com/qna/0,289202,sid87_gci1166243,00.html http://www...