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 <gryz...@gmail.com> > BETWEEN X AND Y > > On Mon, Apr 20, 2009 at 2:55 PM, Rafael Domiciano > <rafael.domici...@gmail.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 >
