Re: SQL With Dates

Hello Grzegorz,

Thnks for response, but lot of the selects is using BETWEEN and the cost is
the same.

2009/4/20 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>

> BETWEEN X AND Y
>
> On Mon, Apr 20, 2009 at 2:55 PM, Rafael Domiciano
> <rafael(dot)domiciano(at)gmail(dot)com> wrote:
> > Hello People,
> >
> > I have initiated a work to review the sqls of our internal software.
> > Lot of them he problem are about sql logic, or join with table
> unecessary,
> > and so on.
> > But software has lot of sql with date, doing thinks like:
> > [..]
> > date >= '2009-04-01' AND
> > date <= '2009-04-15'
> > [..]
> >
> > Redoing the SQL with fix date (date = '2009-04-01') o cost in explain
> always
> > still about 200 or less. But with a period the cost is high, about 6000
> or
> > more.
> >
> > Select is using Index and the date is using index too.
> >
> > There is some way to use date period with less cost?
> >
> > Rafael Domiciano
> >
>
>
>
> --
> GJ
>