Query taking long time
Need some help in optimizing the query. Please recommend some steps to optimzing the query. it is taking around 18 mins to execute. checked the waits stats , I see pageiolatch, io_completion etc…
Please let me know if you need any info from my end.
Thanks in advance.
But also, you have lots of lookups. If you use 'included columns' in your non-clustered indexes, you can avoid those lookups and should see significant improvement.