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