Online Documentation for Data Pump for SQL Server

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 - an index in which the logical order of the key values determines the physical order of the corresponding rows in a table. The bottom, or leaf, level of the clustered index contains the actual data rows of the table. A table or view is allowed one clustered index at a time


CheckBox Drop existing - specifies whether the existing index should or should not be dropped before creating the new one


CheckBox Fill factor - specifies a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild


CheckBox Ignore duplicate keys - specifies the error response to duplicate key values in a multiple-row insert operation on a unique clustered or unique nonclustered index


CheckBox Pad index - determines whether the percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index


CheckBox Do not recompute statistics - specifies that out-of-date index statistics are not automatically recomputed


<< Back to editing target objects