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
21652
September 20, 2005 12:15PM
9690
September 20, 2005 03:18PM
Re: Rows Examined, why so many?
6026
September 21, 2005 08:12AM
4859
September 20, 2005 03:54PM
4425
September 20, 2005 07:10PM
4259
September 21, 2005 05:05AM
4170
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.