About Join and Hash Index Version Considerations - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

You can copy join and hash indexes as part of a full database copy using ARC. Copying a database with join or hash indexes on the target but no corresponding indexes in the source re-creates the target indexes after the entire database is copied.

To copy join and hash indexes when copying an entire database, set the optional database.copy.joinIndex configuration property to true as shown in the following sample configuration.xml:
<property>
    <key>database.copy.joinIndex</key>
    <value>true</value>
    <description>Purpose: If set to true, all Join Index and Hash Index associated with a table will automatically be copied to the target when copying the table between DBS version 13.0 or higher. This parameter is only used to support previous functionality of Data Mover. The default is false.</description>
</property>