Just wondering... I have this simple join: SELECT b.id_commentaire AS id_commentaire, id_skynaute, id_article, created_on, read, expediteur, email, text FROM comment_base AS b LEFT JOIN comment_content AS c USING (id_commentaire) WHERE id_skynaute = 4671022 AND id_article = 58366086;
id_commentaire is the primary key of comment_base and comment_content tables. id_skynaute and id_articles are non-unique keys of comment_base. The slow query log shows: # Query_time: 9 Lock_time: 0 Rows_sent: 1601 Rows_examined: 3187 EXPLAIN shows that only indexes are used: id_article from comment_base and id_commentaire (primary key) from comment_content. My obvious question is: why 3187 rows were examined since everything is indexed and there's only one matching entry of the comment_content table for every comment_base entry? Best regards, -- Frank - my stupid blog: http://00f.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
