Using partitioning
Tables (and indexes) may become very large in a database, driving performance and maintenance problems.
Partitioning is the way to improve performance in large tables (Oracle suggests to partition tables with more than 2 GB of data), to ease the configuration and care of these objects and to reduce downtime in case of failures or scheduled maintenance such as move the tables or take some data offline.
In this recipe, we discuss partitioning a table using range partitioning. We will present hash, list, and composite partitioning as options.
How to do it...
We can create a table range partitioned adding the PARTITION BY RANGE clause to the CREATE TABLE statement:
CREATE TABLE SALES_RP ( PROD_ID NUMBER NOT NULL, CUST_ID NUMBER NOT ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
