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!

Hint to disable partition wise join

673580Dec 9 2008 — edited Dec 11 2008

Is there a way to disable partition wise join(serial) in 10gR2? i.e. via hint.. The reason I want to do this is, to use intra-partition parallelism for a very big partition. re-partitioning or subpartitioning is not an option for now. SQL is scanning only one partition so P-W join is not useful and it limit the intra-partition parallelism.

TIA for your answers.

This post has been answered by Jonathan Lewis on Dec 11 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2009

Added on Dec 9 2008

#general-database-discussions

5 comments

3,224 views