© Michelle Malcher and Darl Kuhn 2019
Michelle Malcher and Darl KuhnPro Oracle Database 18c Administrationhttps://doi.org/10.1007/978-1-4842-4424-1_12

12. Partitioning: Divide and Conquer

Michelle Malcher1  and Darl Kuhn2
Huntley, IL, USA
Morrison, CO, USA

Oracle provides two key scalability features that enable good performance, even with massively large databases: parallelism and partitioning. Parallelism allows Oracle to start more than one thread of execution to take advantage of multiple hardware resources. Partitioning allows subsets of a table or index to be managed independently (Oracle’s “divide and conquer” approach). The focus of this chapter is partitioning strategies.

Partitioning lets you create a logical table or index that consists ...

Get Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.