Renaming and Relocating Hash and Join Indexes - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
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>
		<associate_table>
			<database>SrcDatabase</database>
			<table>SrcTable</table>
		</associate_table>
	</index>
</indices>