Skip to Main Content

SQL & PL/SQL

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!

SQL performance issue

630509Oct 14 2012 — edited Oct 15 2012
Hi Brothers

What is the difference between below 2 queries. are they same?

select * from T1
LEFT JOIN
(
A1 JOIN A2
ON A1.oi_id = A2.pk_id
)
ON (T1.ext_id = A1.ext_org_id1)

select * from T1
LEFT JOIN ON
(select oi_id, pk_id from A1, A2 where A1.oi_id = A2.pk_id)A3
ON (T1.ext_id = A3.ext_org_id1)

First Query is running forever, where 2nd is very very fast.

Thanks for you support in advance.

Regards
Sunil Mohanty
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2012
Added on Oct 14 2012
4 comments
142 views