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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 7 days, processed 282,280,624 queries (421/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]