List:General Discussion« Previous MessageNext Message »
From:C.R.Vegelin Date:April 29 2008 12:12pm
Subject:why is explain.key-len not size of key field ?
View as plain text  
Hi All,

I have a dictionary table like:
CREATE TABLE IF NOT EXISTS `mydictionary`
(
  `EN` varchar(36) default NULL,
  `DE` varchar(36) default NULL,
  `ES` varchar(36) default NULL,
  `FR` varchar(36) default NULL,
  `IT`   varchar(36) default NULL,
  `NL` varchar(36) default NULL,
  `PT` varchar(36) default NULL,
  KEY `EN` (`EN`),
  KEY `DE` (`DE`),
  KEY `ES` (`ES`),
  KEY `FR` (`FR`),
  KEY `IT` (`IT`),
  KEY `NL` (`NL`),
  KEY `PT` (`PT`)
) ENGINE=MyISAM DEFAULT CHARSET = UTF8;

When I run the query:
EXPLAIN SELECT `EN`, `FR` FROM `mydictionary` 
WHERE `FR` Like "comp%" ORDER BY `FR`;

EXPLAIN says:
select type = SIMPLE, type  =  range, key  =  FR, 
key-len  =  111, ref  = NULL, extra  =  using where

Any idea why key-len is 111 ?

Thanks, Cor



Thread
why is explain.key-len not size of key field ?C.R.Vegelin29 Apr
  • Re: why is explain.key-len not size of key field ?Rob Wultsch29 Apr
  • Re: why is explain.key-len not size of key field ?C.R.Vegelin29 Apr
    • Re: why is explain.key-len not size of key field ?Rob Wultsch29 Apr
  • Re: why is explain.key-len not size of key field ?C.R.Vegelin29 Apr