Creating and Using Partitioned Tables

摘要

able partitioning is a data organization scheme in which table data is divided across multiple storage objects called data partitions, based on values in one or more columns. A partitioned table can contain significantly more data than an ordinary table; yet, by taking advantage of a process known as partition elimination, queries run against partitioned tables typically execute faster and require less disk I/O than when they are run against nonpartitioned tables. (The DB2 Optimizer is data-partition aware, and only relevant data partitions are scanned during query execution.)