You cannot create a join 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 join index, use the following general procedure.
- Create the new join 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.