List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:September 21 2003 6:13pm
Subject:Re: explain
View as plain text  
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)
Thread
explainHsiu-Hui Tseng19 Sep
  • RE: explainDathan Vance Pattishall19 Sep
  • Re: explainJeremy Zawodny20 Sep
    • RE: explainHsiu-Hui Tseng20 Sep
      • Re: explainJeremy Zawodny21 Sep
  • Re: explainMatt W20 Sep