merge join with remote table takes 1 hour

Remote query on linked server is 100 precent of costs and runs for 1 hour

tmpBA38.queryanalysis (164.0 kB)
avatar image By ob123 1 asked Jul 11, 2015 at 07:48 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.

Follow this question

Topics:

x691
x502
x6
x5

asked: Jul 11, 2015 at 07:48 PM

Seen: 198 times

Last Updated: Jul 11, 2015 at 07:48 PM

Related Questions

Optimizer Chose Merge Join, I hinted Loop join and much better performance. Why?

Sort or No sort before merge join depending on order columns in join condition

Remote Query Execution versus Local Query Execution

Different plan gets generated when passing DateTime parameter

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