10.5 Specifying Multiple Partitioning Keys in a RANGE Partitioned Table

Table of Contents Previous Next


10 Table Partitioning : 10.5 Specifying Multiple Partitioning Keys in a RANGE Partitioned Table

You can often improve performance by specifying multiple key columns for a RANGE partitioned table. If you often select rows using comparison operators (based on a greater-than or less-than value) on a small set of columns, consider using those columns in RANGE partitioning rules.
Since all rows with a value of 8 in the sale_month column and a value of 2012 in the sale_year column will be stored in the q3_2012 partition, Advanced Server searches only that partition.

10 Table Partitioning : 10.5 Specifying Multiple Partitioning Keys in a RANGE Partitioned Table

Table of Contents Previous Next