New to Query Tuning

I have started tuning queries recently. Apart from the obvious Table Scan in this plan, can you please point me in the right direction. I would really appreciate your inputs Thank you Jack

tmp511E.queryanalysis (1.1 MB)
avatar image By hpjack433 1 asked Jul 25 at 01:59 PM
more ▼
(comments are locked)
avatar image Matak Jul 25 at 11:13 PM

This is only an estimate. Can you attach the actual plan ? Can you also run the inside of the view so we can see how it is constructed ?

10|10000 characters needed characters left
▼ Viewable by all users
0
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:

x600
x415
x109
x107
x11

asked: Jul 25 at 01:59 PM

Seen: 285 times

Last Updated: Jul 25 at 11:13 PM

Related Questions

Two Servers. Two radically different plans.

Same Query, Two Plans, One Stinks

Component running slow

Is there a better way to search for matches

Execution plan mystery

Any idea why the filter limiting to 5K instead of 320K rows is done at the end ?

How can I improve this plan. Table Insert is costing the most at 84.6% - can it be improved ?

A filter with the attached query causing slowness and performance issues

Trying to understand why partition elimination is happening in some plans, but not others

Slow query - I think my index is just making things worse :(