Hello,
update of my last email sent.
when i use the
sql: 'EXPLAIN SELECT datum FROM actions ORDER BY datum'
the key gets used:
table type possible_keys key key_len ref rows Extra
actions index NULL datum 8 NULL 75859 Using index
however as soon as i select more column like
sql: 'EXPLAIN SELECT datum,id FROM actions ORDER BY datum'
the key isn't used anymore :-(.
might this be bug of mysql?
Corin
---
This is a forwarded message
From: Corin Langosch <clangosch@stripped>
To: mysql@stripped
Date: Tuesday, December 9, 2003, 10:11:03 AM
Subject: key is not used
===8<==============Original message text===============
Hello,
i'm having a problem with mysql. when i put an index on a
datetime column, it's never used.
for example the
sql: 'EXPLAIN SELECT * FROM actions ORDER BY datum'
shows:
table type possible_keys key key_len ref rows Extra
actions ALL NULL NULL NULL NULL 75853 Using filesort
even if i use the
sql: 'EXPLAIN SELECT * FROM actions USE INDEX (datum) ORDER BY datum'
mysql doesn' use the index :-((
tahnks for any help,
corin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
===8<===========End of original message text===========
