"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 03/03/2005 02:38:54 PM:
> Hello, > > Does this mean a key is not being used? > > mysql> explain select vl_ts from view_log where vl_uid='bbbbbb'; > +----------+------+---------------+------+---------+------+------ > +------------+ > | table | type | possible_keys | key | key_len | ref | rows | Extra > | > +----------+------+---------------+------+---------+------+------ > +------------+ > | view_log | ALL | vluid | NULL | NULL | NULL | 60 | where > used | > +----------+------+---------------+------+---------+------+------ > +------------+ > > Thanks, > -Jon > > The short answer is "YES, there was no key used to answer the query". Please read: http://dev.mysql.com/doc/mysql/en/explain.html for more details on how to read the EXPLAIN output. Please also read: http://dev.mysql.com/doc/mysql/en/where-optimizations.html for some of the reasons why your index was not used to answer your query. Shawn Green Database Administrator Unimin Corporation - Spruce Pine