Remote query on linked server is 100 precent of costs and runs for 1 hour
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x671
plan explorer upload x481
linked server x5
asked: Jul 11, 2015 at 07:48 PM
Seen: 190 times
Last Updated: Jul 11, 2015 at 07:48 PM
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.
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
© 2013 SQL Sentry, Inc. All rights reserved.