what is wrong with this Plan, this query is on a kimball model database and is very slow

tmpB5C1.pesession (50.2 kB)
avatar image By Ankit 0 asked Jul 19, 2017 at 04:11 PM
more ▼
(comments are locked)
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.

We are Moving!

<p><br></p>

Follow this question

Topics:

x692
x503
x1
x1

asked: Jul 19, 2017 at 04:11 PM

Seen: 40 times

Last Updated: Jul 19, 2017 at 04:11 PM

Related Questions

This query is very slow. I am new to spatial indexes and am not sure where to begin tuning this query.

Query Rewrite

How can I avoid this bad plan

I would like to reduce the access to these tables: fact_input_output, dim_org_v, rap_combo

How can I further optimise this query?

How to improve performance

How to get rid of Hash Join and Sort

Help Optimizing View

Estimated way too less compared to Actual no of rows

Statistics problem?