Postgres Pro
Downloads
Home   >   mailing lists

Indexes? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Indexes?
Date
Msg-id 41AEB211.2050202@havleik.no
Whole thread Raw
Responses Re: Indexes?  (Bruno Wolff III <bruno@wolff.to>)
Re: Indexes?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
I have a table where I need to use "..where curdate between fromDate and toDate".
Is it best to have two indexes, one for FromDate and one for toDate or just one index for
both the fields?


Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Upcoming Changes to News Server ...
Next
From: Mark Pratt
Date:
Subject: PostgreSQL Authors wanted