List:General Discussion« Previous MessageNext Message »
From:Corin Langosch Date:December 9 2003 9:20am
Subject:update: key is not used
View as plain text  
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===========


Thread
key is not usedCorin Langosch9 Dec
  • Re: key is not usedMartijn Tonies9 Dec
    • Re[2]: key is not usedCorin Langosch9 Dec
      • Re: key is not usedChuck Gadd9 Dec
  • update: key is not usedCorin Langosch9 Dec
    • Re: update: key is not usedEgor Egorov9 Dec
  • Re: Re[2]: key is not usedMartijn Tonies9 Dec