where is the best placeto start here ? Thanks

DjadAL 2017-03-08 16:12:41

Aaron Bertrand 2017-03-09 16:54:39
Tough to really dig in without the text of the view, because my first thought is why so many different operators against different indexes on the Aging table, what is causing the sort of 484 million rows, why there are so many RID lookups, why every single table is a heap… can you give some more background here?
DjadAL 2017-03-09 20:02:32
Hi Aaron,

Thanks for responding, my idea is to start and create Primary keys or cluster indexes on those table. and try to add the proper no cluster index on the table that are being accesses in this View. this usualy take about 8 min to run. it's doing over billion logical read and there are lots RID lookup. i have attached the view