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.
- Open the parameters.xml file that has the job definition information for the job.
- Create an <indices> section.
- Add the selection="included" attribute to an <index> element.
- Specify the name of the join or hash index using a <name> element.
- 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>