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
[EMAIL PROTECTED] ----------------------------------------------------------------------------------------------- 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" -----------------------------------------------------------------------------------------------
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
