Adds the partition column to a non-unique index.

Select global, local, or global for unique indexes. The smart partitioning process recreates indexes according to the segmentation policy you configure. If the source table index was previously partitioned, the segmentation process might drop the original partitions. Default is local.

Select local bitmap or global regular. Default is local bitmap.

The degree of parallelism the ILM Engine uses to create and alter tables and indexes. Default is 4.

Number of parallel processes the ILM Engine uses in the compile invalid objects step. Default is 4.

Select dynamic, context sensitive, or shared context sensitive.

The sampling percentage. Valid range is 0-100. Default is 10.

Select no histogram or all global indexed columns auto histogram.

Drops the original tables after you create segments.

Flag that indicates if you want to merge archived history data with production data when you run the segmentation policy. If set to Yes, the ILM Engine includes the history data during the Create Audit Snapshots steps and the Compare Audit Snapshot step of the segmentation process.

If you have enabled interim table processing to pre-process business rules, the partitioning process can drop any existing interim tables for the segmentation group and recreate the interim tables. Select Yes to drop existing interim tables and recreate them. If you select No and interim tables exist for the segmentation group, the partitioning process will fail.