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.11
Published
October 2021
Language
English (United States)
Last Update
2021-10-14
dita:mapPath
cai1626458602965.ditamap
dita:ditavalPath
cai1626458602965.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.