slow query

Question

Post reply

slow query

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Jeffrey Williams wrote:

Could you post the plan here: https://www.brentozar.com/pastetheplan/%5B/quote%5D

Frederico attached a converted copy as a ZIP file.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

frederico_fonseca SSCoach Points: 16154 More actions · Answer 2

Jeffrey Williams wrote:

Could you post the plan here: https://www.brentozar.com/pastetheplan/%5B/quote%5D

I've already uploaded it here as a zip file.

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

frederico_fonseca wrote:

Jeffrey Williams wrote:

Could you post the plan here: https://www.brentozar.com/pastetheplan/%5B/quote%5D
I've already uploaded it here as a zip file.

I saw that after I posted...thanks.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

thenewbee SSC Eights! Points: 861 More actions · Answer 4

Hi All,

Thanks for your valuable feedback, I'm working on the query now and hope it will improvise

Thanks

NB

thenewbee SSC Eights! Points: 861 More actions · Answer 5

Sorry, I forgot to ask- is parallel execution worse, how to avoid parallel execution

thenewbee SSC Eights! Points: 861 More actions · Answer 6

@Erikur, Sorry, I forgot to ask- is parallel execution worse, how to avoid parallel execution

frederico_fonseca SSCoach Points: 16154 More actions · Answer 7

parallel is not necessarily worst - in many cases is it a lot faster than serial but it all depends.

as we mentioned before we need full code including underlying views and functions to be able to help further - failing that you will need to do the work of converting all those views/functions into a stored proc that behaves well.

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 8

thenewbee wrote:

@Erikur, Sorry, I forgot to ask- is parallel execution worse, how to avoid parallel execution

As Frederico stated, it is neither better nor worse, it depends. For high cardinality sets with a sorted output, parallelism is normally worse, but this is a thing that has to be tested.

😎

To prevent parallel execution, simply add "OPTION (MAXDOP 1)" at the end of the query.

Can you elaborate further and post the full code as previously requested?

thenewbee SSC Eights! Points: 861 More actions · Answer 9

Thanks .... they haven’t agreed to it... I will have to do some trial and error based on your recommendations