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!

Performance improvement of cartesian product

505142Jan 21 2008 — edited Jan 21 2008

Hi,
I am joining two views without any condition i.e. cartesian product.
Both views are taking less then 1 sec. if I am running individually.
but while performing cartesian product it is taking more then 2 min.

I am using Oracle 8.0.2

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2008

Added on Jan 21 2008

12 comments

816 views