Considerations with Join and Hash Index Versions | Teradata Data Mover - Join and Hash Index Version Considerations - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
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 DSA, but not as part of a full database relocation where the target database name is not the same as the source database name. Copying a database with join or hash indexes on the target, but no corresponding indexes on the source, re-creates the target indexes after the entire database is copied, if any indexes exist on the target database.

To copy join and hash indexes when copying an entire database using DSA, 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>
DSA automatically copies join or hash indexes when the source or target database version is earlier than 16.20 regardless of the database.copy.joinIndex value.