Re: Question regarding query optimising with between

2001-03-07 Thread Dan Nelson
In the last episode (Mar 06), Christian Hammers said: I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end

Question regarding query optimising with between

2001-03-06 Thread Christian Hammers
Hello I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end between '2001-01-01' and '2001-04-01' affects just one