Re: [PERFORM] [HACKERS] BETWEEN optimizer problems with single-value

2006-03-15 Thread Kevin Grittner
>>> On Wed, Mar 15, 2006 at 5:05 pm, in message <[EMAIL PROTECTED]>, Simon Riggs <[EMAIL PROTECTED]> wrote: > On Wed, 2006- 03- 15 at 11:56 - 0600, Kevin Grittner wrote: > >> (One obvious way to fix it would be to >> rewrite "BETWEEN a AND b" as "= a" when a is equal to b, but it seems >> like t

Re: [PERFORM] [HACKERS] BETWEEN optimizer problems with single-value range

2006-03-15 Thread Simon Riggs
On Wed, 2006-03-15 at 11:56 -0600, Kevin Grittner wrote: > Attached is a simplified example of a performance problem we have seen, > with a workaround and a suggestion for enhancement (hence both the > performance and hackers lists). > > Our software is allowing users to specify the start and end