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.