Thanks guys all your input. Tuning of query is given to me in the morning, i have no idea about the query and database involved. Thank fully i went for Database Tuning Adviser for right indexes. DTV suggested some NON CLUSTERED INDEXES and STATISTICS. I took these and applied. It worked for me. Now queries are bit faster .