How to reduce high cost of sort on execution plan

Ask Question

Asked 3 months ago

Modified 3 months ago

Viewed 55 times

I have a very large query with three UNION ALL and it takes 30 minutes to execute.

Analyzing the execution plan I see that it has a high cost in SORT and Filter.

I tried to generate the showplan in XML but it's more than 2MB.

I put the complete query in OneDriver because it has 104364 characters

Could someone help me to improve the execution time of the query?

Thanks.

asked Feb 16 at 19:42

Carlos D

213 bronze badges

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.