Database Reference
In-Depth Information
Figure 12-13.
Configuring the location and aggregation settings
The last radio button, “Copy the aggregation design from an existing partition,” allows you to do just what it
says, copy a previously created partition. If this radio button is checked, then the “Copy from” dropdown box will
activate, and you can select the aggregation to copy. You can then click Finish to complete the wizard.
After the wizard completes, the Partitions tab shows the name of your new partition along with either the
table or the select statement that identifies its source, the current estimated number of rows in the partition, and
the storage design (Figure
12-14
).
Figure 12-14.
The Partitions tab after two partitions have been created on the Fact Sales table