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.
© Michelle Malcher and Darl Kuhn 2019Michelle Malcher and Darl KuhnPro Oracle Database 18c Administrationhttps://doi.org/10.1007/978-1-4842-4424-1_12
12. Partitioning: Divide and Conquer
Partitioning lets you create a logical table or index that consists ...