MySQL Forums
Forum List  »  Optimizer & Parser

Re: Rows Examined, why so many?
Posted by: matt roberts
Date: September 21, 2005 08:12AM

WOAH! This article is the PERFECT explanation and makes perfect sense. I get 1959, not 500*4 because there are left joins on profile and members, and some records there do not exist.

I think that they should say "Rows returned: 500", "RECORDS examined: 1959" instead of rows. That would have given me a hint :)

Thanks a lot Daniel, very good article, and i can stop banging my head ! Why didn't I think about posting here rather than banging my head against the wall for 2 months!

Options: ReplyQuote


Subject
Views
Written By
Posted
16172
September 20, 2005 12:15PM
8219
September 20, 2005 03:18PM
Re: Rows Examined, why so many?
5103
September 21, 2005 08:12AM
4131
September 20, 2005 03:54PM
3823
September 20, 2005 07:10PM
3644
September 21, 2005 05:05AM
3559
September 21, 2005 08:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.