On Thu, Dec 02, 2004 at 07:11:29AM +0100, Bjørn T Johansen wrote: > 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?
You could try it both ways and use EXPLAIN ANALYZE to see which results in a faster plan, if that's what you mean by "best." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
