. Can this query performance be improved further? Will statistics or other indexes get better estimated row counts and hence better performance?

There is a big difference between the estimated rows & actual rows. A number of operations are clustered index scans, but the predicates are the full index columns. These appear to be scan rather than seeks due to the parallelism of the bitmap probe operator being used. Can this query performance be improved further? Will statistics or other indexes get better estimated row counts and hence better performance?

I've done quite a bit of optimisation, reducing the original query time from 90mins to 9mins. Covering indexes & query reformulation using exists & outer apply had been quite helpful.

avatar image By ajc 0 asked Feb 03, 2016 at 06:31 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x4
x4
x1

asked: Feb 03, 2016 at 06:31 AM

Seen: 39 times

Last Updated: Feb 03, 2016 at 06:31 AM