September 20, 2006 at 11:24 am
Has anyone found a way to tune your way past a lazy table spool without doing a complete re-write? A couple of times I have seen an execution plan change and the optimizer starts picking a table spool. Nothing but a re-write (they probably needed it anyway) worked.
If you've had success please post what you did.
September 21, 2006 at 1:01 am
I generally don't like to see spools but it's a matter of scale - did you find it because the query runs poorly, in which case you need to make changes, or just noticed it, in which case if it ain't broke don't fix it.
I don't find many spools - my usual first step is to create indexes which cover just about everything and see if any of my suggestions please the optimiser!!! As always it just depends.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply