At 5:15 PM +0000 02-02-2000, James Gray wrote:
>(clearer)
>
>I am looking at the result of an "explain select" that does *not* perform a
>join,
>I'm getting a 'ALL' in 'type' - the documentation describes this as very bad
>but I'm not performing a join, is this still very bad?
>
>Thanks:
>
>mysql> EXPLAIN SELECT * FROM BOOKS WHERE BOK_AUTHOR LIKE "Grisham%";
>+-------+------+---------------+------+---------+------+---------+----------
>--+
>| table | type | possible_keys | key | key_len | ref | rows | Extra
>|
>+-------+------+---------------+------+---------+------+---------+----------
>--+
>| BOOKS | ALL | NULL | NULL | NULL | NULL | 1041289 | where
>used |
>+-------+------+---------------+------+---------+------+---------+----------
>--+
>1 row in set (0.00 sec)
Is the BOK_AUTHOR column indexed?
--
Paul DuBois, paul@stripped
