Subscribe to this blog
Archives: December 2010
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in recompiles”
Ok, it sounds reasonable, if the optimiser optimises for the execution path taken on first execution it’ll have to go back and optimise the other paths when they are… Read more
11 comments, 316 reads
Posted in SQL In The Wild on 14 December 2010