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


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