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 - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
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>