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 <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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/[EMAIL PROTECTED] ===8<===========End of original message text=========== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
