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/