You cannot create a hash index for a table while that table is subject to dynamic AMP sample emulation. To disable dynamic AMP sampling, contact the Teradata Support Center.
To use dynamic AMP sampling on the table with a new hash index, use the following general procedure:
- Create the new hash index on the table on the target system.
- Extract a fresh dynamic AMP sample from the target system.
- Apply the fresh sample to the source system.