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!

merge cartesian join in query plan

Vishal R.Sep 9 2010 — edited Sep 9 2010

Hi All

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

W are using many GTT's in our code, the query plan have Merge Cartesain join showing cardinality as '1' which is incorrect, as GTT tables have many rows. Due to this query is taking ages to execute.

I am trying to sue dynamic sampling, but it doesn't seem to work.

please help on this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2010

Added on Sep 9 2010

4 comments

735 views