Re: Reading Nested Loop Xplans
From: Taral Desai <taral.desai_at_gmail.com>
Date: Fri, 14 Sep 2012 09:47:25 -0500
Message-ID: <CAO4+9HXCvmLZQd-NXP5S40HoG2=NL7g6ZcgHUCR67hukuveQtg_at_mail.gmail.com>
Step 3 Will return 53162 rows..and that many times it has to loop that table_01 via pk_msg_person.
And if i am not mistaken then you are on 11g so that's why you are seeing two nested loop.which is NLJ batching. Hash unique is obvious due to distinct..Hope this helps.
Date: Fri, 14 Sep 2012 09:47:25 -0500
Message-ID: <CAO4+9HXCvmLZQd-NXP5S40HoG2=NL7g6ZcgHUCR67hukuveQtg_at_mail.gmail.com>
Step 3 Will return 53162 rows..and that many times it has to loop that table_01 via pk_msg_person.
And if i am not mistaken then you are on 11g so that's why you are seeing two nested loop.which is NLJ batching. Hash unique is obvious due to distinct..Hope this helps.
--
Thanks & Regards,
Taral Desai
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 14 2012 - 09:47:25 CDT