Rename and Relocate Hash and Join Indexes | Teradata Data Mover - 17.10 - Renaming and Relocating Hash and Join Indexes - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)
Use the target_name and target_index_database elements to rename and relocate hash and join indexes.

Both elements are optional and can be used in any combination. If only the target_name element is specified, the target index database name will be the same as the source index database name. If only the target_index_database tag is specified, the target index name will be the same as the source index name.

  1. Add the target_name and target_index_database elements under the index element.
This is shown in the following example:
<indices>
	<index selection="included">
 	<name>SrcHashIndex</name>
		<target_name>TargetHashIndex</target_name>
		<index_database>SrcDatabase</index_database>
		<target_index_database>
			<name>TargetDatabase</name>
		</target_index_database>
		<index_type>HASH_INDEX</index_type>
	</index>
</indices>