I have fixed all the implicit conversion issues, but this query still takes atleast 13 mins to return 830 rows.
Richard, this forum is currently experiencing issues with attachments so your plans are not accessible.
Can you post the plan on another site, then post a link here? (You can use Brent Ozar's site at https://www.brentozar.com/pastetheplan/ if you want to share just the plan, or just about any site that allows you to upload and share any-format binary files if you want to share the full .pesession data)
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 x691
plan explorer upload x502
sql performance joins x2
asked: Jun 11 at 01:46 PM
Seen: 6 times
Last Updated: Jun 11 at 07:11 PM
I have fixed all the implicit conversion issues, but this query is still too slow
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
How to get rid of Hash Join and Sort
Help Optimizing View
Estimated way too less compared to Actual no of rows
© 2013 SQL Sentry, Inc. All rights reserved.