Re: Rows Examined, why so many?
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!
Subject
Views
Written By
Posted
21305
September 20, 2005 12:15PM
9547
September 20, 2005 03:18PM
Re: Rows Examined, why so many?
5912
September 21, 2005 08:12AM
4779
September 20, 2005 03:54PM
4344
September 20, 2005 07:10PM
4172
September 21, 2005 05:05AM
4085
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.