Speeding up sorting subtree

If I execute the stored procedure generating this plan to return data for a single date, the execution finishes in < 3 minutes. When I pass a date range into the procedure, the run takes almost 20 minutes. I understand since more records are being returned there will be an obvious time increase, but I am curious where I would look and how I would begin to speed up queries where the brunt of the overhead is on the sorting subtree. any help is appreciated.

avatar image By deadLock 0 asked Jun 23 at 04:41 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

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:

x631
x445
x4
x3
x2

asked: Jun 23 at 04:41 PM

Seen: 26 times

Last Updated: Jun 23 at 04:41 PM