Hi, Iam trying to execute one query. where query inclued many tables (which has primary key and foreign key's). Its taking 5 min 38 sec's long time to execute... I found the missing indexes by using dmv query. what I have to do next... to improve the performance of query Iam giving details abt tables, keys, indexes and exicuting query also.. gimme suggetions to improve performance of above query.. thankx
First , welcome to Forums ... Could you forward to me the definitions of tables .... Also , for indexing part , you might have a look at my blog for this regard http://www.sqlserver-performance-tu...w/12927042-towards-t-sql-queries-of-0-sec-6-6-