O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required