List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 2 2000 6:01pm
Subject:RE: Explain type 'ALL'.
View as plain text  
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
Thread
Explain type 'ALL'.James Gray2 Feb
  • Re: Explain type 'ALL'.Matthias Urlichs2 Feb
  • Re: Explain type 'ALL'.sasha2 Feb
RE: Explain type 'ALL'.James Gray2 Feb
  • Re: Explain type 'ALL'.sasha2 Feb
  • RE: Explain type 'ALL'.Paul DuBois2 Feb
RE: Explain type 'ALL'.James Gray2 Feb
  • DELETETony) (Nestor2 Feb
    • Re: DELETEMr. Anthony R.J. Ball2 Feb
    • Re: DELETEDaniel Beckham2 Feb
    • Re: DELETEBlain Nelson2 Feb
  • RE: Explain type 'ALL'.Paul DuBois2 Feb
RE: Explain type 'ALL'.James Gray2 Feb