Re: explain

[Jeremy Zawodny]

On Fri, Sep 19, 2003 at 10:20:34PM -0700, Hsiu-Hui Tseng wrote:
> These 2 are the queries
> 
>  explain select * from user where user_id = 123;
>  -> where user_id is the primary key of user table with 2178576 rows.

Is there a user with user_id 123?
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 7 days, processed 282,280,624 queries (421/sec. avg)