Skip to Main Content

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!

Hash Partition

9135487Oct 11 2012 — edited Oct 12 2012
Hi,

i want to know whether hash partition is benificial in terms of performance. For example if DRL is performed on a table that has 10 hash partitions, as peer my understanding that DRL would scan the whole table as hash partition just distributes data equally among partitions without specifying any values.
Please advice.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2012
Added on Oct 11 2012
19 comments
352 views