I have a procedure, which is running very slow, and is being timed out without returning any records. [Reports] Table is already generated by another SP, which creates indexes on this underlying table ([Reports]) and this SP just reads data from this [Reports] table.
Approx number of records 150K and is taking more than 15 minutes to load this data.
End user needs "Select All" for all filters i.e. they need data for all filters available on report.
I have added current execution plan for slow procedure and underlying table structure:
What could be the reason for slow performance?
Things I have tried:
But there is no improvement in performance.
Please let me know if additional information is required to answer this question and give suggestions
By biandsqluser 1 asked Dec 05, 2016 at 11:07 AM