Hiep Nguyen wrote:
i believe "date" is a reserved word for mysql. don't use reserved word
for the column name. it's confused.
Using reserved words may be confusing, but it is fine as long as you put
them between backticks, as I'm sure the OP is aware of.
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]
