i believe "date" is a reserved word for mysql. don't use reserved word for
the column name. it's confused.
On Tue, 20 Mar 2007, Peter wrote:
Hello,
I have a a large a table which a field called date, type date.
When I select a smaller range e.g 3 months system uses the index 'date'.
That is for let's say 2 million rows.
If I select wider date range mysql stops using key. It says possible key
"date", but do not use it and goes over all 28 Million rows.
If I use "force index" the query becomes even slower.
Table type is Myisam.
Please advise what should I tune so mysql uses the index without force
index and query becomes faster.
Thanks :-)
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
