| There are many compelling reasons to implement Oracle partitioning for larger databases, and Oracle partitioning has become the de-facto standard for systems over 500 gigabytes. Oracle partitioning has many benefits to improve performance and manageability: |
| Faster SQL – Oracle is partition-aware, and some SQL may improve is speed by several orders of magnitude (over 100x faster). |
| Index range scans – Oracle partitioning physically sequences rows in index-order causing a dramatic improvement (over 10x faster) in the speed of partition-key scans. |
| Full-table scans – Oracle partition pruning only accesses those data blocks required by the query. |
| Table joins – Oracle partition-wise joins take the specific sub-set of the query partitions, causing huge speed improvements on nested loop and hash joins |
| Updates – Oracle parallel query for partitions improves batch load speed. |
Comments