Re: key partition
The performance depends on the usage.
if you only do lookups by partition key and it is not indexed, then it will be faster the more partitions you use, since it will scan a smaller piece of the table.
if you do not include the partition key it will be slower the more partitions you use, since you only adding overhead by partitioning without using the benefit of pruning.
Subject
Views
Written By
Posted
2672
April 12, 2012 06:28AM
Re: key partition
1962
April 13, 2012 08:16AM
1833
April 13, 2012 04:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.