You can copy data, statistics, or both data and statistics for hash or join indexes to a target Teradata system. You can also give indexes a different name or copy them to a different database on the target.
- In the Objects tab, click
to expand the tree. - Click to expand a database or user object where the join or hash index is located.
- To filter so only hash indexes or join indexes display, do the following:
- Click
and clear all check marks except for Join Index or Hash Index. - Move the cursor off of the object-types filter to refresh the tree with indexes in the sub-branch.
- Click
- Click
to display the index settings dialog box.The name of the index displays at the top of the dialog box. - [Optional] From the Copy the following list, select an option for the copy job:
- Only definition
- Only statistics
- Both definition and statistics
- [Optional] To use an alternate name for the index on the target database, enter the name in the Rename to box.
- [Optional] To map to a different database on the target, click next to Map to a different database on target.You can use the filter to display only the items that match the characters you enter.
- [Optional] To select the table associated with the index:
- Click Browse.
- Click to expand the tree.
- Click to expand one or more sub-branches.
- Click in the sub-branch to display the object-types filter. Filter the sub-branch by selecting Table.
- Select one or more tables associated with the index.
- Click Select at the bottom of the SELECT ASSOCIATED TABLES view to complete the table selection.The results of your selection appear in a summary table that lists the database and table associated with the index.
- Select OK.