Online Documentation for Data Pump for DB2

Target index properties

The Target object definition area of Step 5 allows you to view and edit the target iconObjects_Index index properties:


Step 5 - Editing target objects - Target index properties


Name - specifies the index name


Columns (read only) - view the column(s) used by the index


CheckBox Unique - determines uniqueness of the index, causes the system to check for duplicate values in the table each time data are added


CheckBox Clustered - specifies that the index is the clustering index of the table


CheckBox Reverse Scans - specifies that the index can support both forward and reverse scans; that is, scanning of the index in the order that was defined at index creation time, and scanning in the opposite order


PCT Free - specifies what percentage of each index page to leave as free space when building the index


Min PCT Used - specifies threshold for the minimum percentage of space used on an index leaf page


<< Back to editing target objects