TomThomson (5/5/2014)
Or did you mean "It depends what the optimizer thinks is best"?
That would be the the one because I've also seen it where the optimizer reused a plan with hashes that it probably shouldn't have.
--Jeff Moden
Change is inevitable... Change for the better is not.