CHAPTER18Partitioning
As the number of rows in your tables grows, the impact on management and performance will increase. Backups will take longer, recoveries will take longer, and queries that span an entire table will take longer. You can mitigate the administrative and performance issues for large tables by separating the rows of a single table into multiple parts. Dividing a table’s data in this manner is called partitioning the table; the table that is partitioned is called a partitioned table, and the parts are called partitions.
Partitioning is useful for very large tables. By splitting a large table’s rows across multiple smaller partitions, ...
Get Oracle Database 12c The Complete Reference 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.
