Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I avoid nested loop

user588120Feb 11 2008 — edited Feb 12 2008

Hai
I have to join 3 tables.In that case there will be nested loop. It is believed that
nested loop will affect the performance adversely. So what i have to do
inorder to avoid nested loop.
If there is anything wrong in my thinking,Please do advice me

Regards
Josh

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2008

Added on Feb 11 2008

#general-database-discussions

3 comments

1,828 views