Attached query/query plan is a part of filter we use in our SSRS reports i.e. it is the query for clicking on a report(later comes the data fetching query part).
We have witnessed this running very slow.
Have tried updating stats and creating missing indexes, but seems no help.
Please help in understanding the cause and what can be done here to improve the performance, as it takes around 10 minutes to display the results when run on SSMS.
By SQLDB 60 asked Apr 09, 2015 at 01:13 PM
Create an index like this on
And this index on
Please capture a new actual plan with those indexes in place and edit your question to add the new
By SQLkiwi ♦ 6.6k answered Apr 09, 2015 at 02:04 PM