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!

How to avoid cartesion join is there any alternate way

653531Jul 7 2009 — edited Jul 8 2009

Hi,

I have table
1.sitemaster
2.Invmaster
Sitemaster will have some hundrer sites and Invmaster will have thousands of items or product
I have an Situation for each site i need to show all product so iam linking with cartetion join but its taking more time
is there any other alternate way to get same result as cartetion join . Please can any one guide me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2009

Added on Jul 7 2009

32 comments

2,886 views