Partitioning: Divide and Conquer

Abstract

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.