Viewing 4 posts - 1 through 5 (of 5 total)
That would be very useful indeed thank you. I understand the reticence for documenting this, but for those of us having to employ the techniques the information would be very...
June 29, 2011 at 11:23 am
The optimizer does contain rules that match on >= and <= but not > and < in some cases.
Brilliant, thanks. Is there anywhere this is documented? That would be incredibly...
June 29, 2011 at 6:33 am
Qualification: Asked another colleague with better memory than me of when we first found this, and we found that the execution plan produced when the >= was replaced with >...
June 29, 2011 at 4:42 am
(I'm kwhytee's colleague.)
I'm pretty certain I've seen significant performance improvements by replacing ">= x" with "> x-1ms" when nothing else has been changed, in certain cases but not always. We...
June 29, 2011 at 4:29 am
Viewing 4 posts - 1 through 5 (of 5 total)