Partitioning allows tables and indexes to be subdivided into smaller pieces, and each small piece (eg., each subset of the overall data) is called a partition.
Partitions are typically created based on a date field.
This article covers how to create a partition schema using the Jet Data Manager, and how to use that partition schema to partition a table.
1. Right-click the table that you would like to setup table partitioning on, and select
2. Click the plus (+) sign to create a partitioning template
3. Give the template a descriptive name, and select among the options available. In this example, we will partition using the
operation, the use of which will become apparent in
4. Complete the partitioning setup by providing values for the following three fields:
Pick the template you created in step #3 from the drop-down list
b. Field: Specify a date field from the table you are partitioning. In this example, I selected Posting Date
c. Time Table: The time table chosen in this list must be a time table (such as the Date table in the data warehouse for all CubeStore project versions up to v2.6)
, and deploy & execute your table. Notice the creation of a new partition field in the format of
inside the table, as well as a Partition Templates folder inside the Jet Data Manager. Partition templates can be re-used in other tables