| Subject | RE: [firebird-support] Query using a range in where/having clause? |
|---|---|
| Author | Steffen Heil |
| Post date | 2004-06-08T05:58:30Z |
Hi
I don't know if the optimizer can convert my query to the one above.
They are equivalent (- maybe up to <= instead of <). But my query could be
easier (and therefor faster) to compute with indices.
Regards,
Steffen
> > > ((ScheduleStart < UserStart) and (ScheduleEnd > UserEnd)) ORwouldn't be covered by any of the 3 conditions that I mentioned?
> > > (ScheduleStart BETWEEN UserStart and UserEnd) OR (ScheduleEnd BETWEEN
> > > UserStart and UserEnd)
> > What about (ScheduleStart < UserEnd) and (ScheduleEnd > UserStart) ?
> Can you give me an example where I would need this condition and that it
I don't know if the optimizer can convert my query to the one above.
They are equivalent (- maybe up to <= instead of <). But my query could be
easier (and therefor faster) to compute with indices.
Regards,
Steffen