Copying Join and Hash Indexes

Teradata Data Mover User Guide

brand
Analytical Ecosystem
prodname
Teradata Data Mover
vrm_release
16.10
category
User Guide
featnum
B035-4101-067K
When copying entire databases using ARC, join and hash indexes on the source database are not automatically copied to the target. You must copy join and hash indexes explicitly.
  1. Open the parameters.xml file that has the job definition information for the job.
  2. Create an <indices> section.
  3. Add the selection="included" attribute to an <index> element.
  4. Specify the name of the join or hash index using a <name> element.
  5. Specify the index type using an <index_type> element. The possible values are HASH_INDEX and JOIN_INDEX.

In the following example, the hash index DBName.Orders_hi associated with the DBName.Orders table is copied to the target when copying the database DBName.

<database selection="included">
	<name>DBName</name>
</database>
		<indices>
			<index selection="included">
				<name>Orders_hi</name>
				<index_database>DBName</index_database>
				<index_type>HASH_INDEX</index_type>
				<associate_table>
					<database>DBName</database>
					<table>Orders</table>
				</associate_table>
			</index>
		</indices>