BETWEEN X AND Y On Mon, Apr 20, 2009 at 2:55 PM, Rafael Domiciano <rafael.domiciano@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
