16.10 - About Estimating the Time Needed To Reassign Maps - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)
To see an estimate of the time needed for planned map reassignments, you can use any of the following methods:
  • Add the table to DBC.ReconfigRedistOrderTbl and run the Reconfig estimator.
  • Experiment with INSERT-SELECT or ALTER TABLE on sample data.
  • Use DBQL step logging to log CPU and I/O for each step. Scale up the numbers to arrive at an estimate.

Use MONITOR SESSION to compare estimates with actual times.