Smash125 (10/25/2013)
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 .
There are still quite some flaws in the design that might need to be addressed.
The Database Tuning Advisor is also not the most optimal tool there is to find. It's possible the indexes are useful for the one query, but they are useless for other queries.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP