Rename and Relocate Hash and Join Indexes | Teradata Data Mover - Renaming and Relocating Hash and Join Indexes - 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
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>