The following table indicates the comparative elapsed times required to insert the same number of 100 byte rows into a base table and join index table.
| Insertion Method | Operation Performed | Elapsed Time (seconds) |
|---|---|---|
| Case 1 | FastLoad into empty table INSERT ... SELECT into base table with join index |
26 99 |
| Total | 125 | |
| Case 2 | Drop join index INSERT ... SELECT into base table without join index Recreate join index |
0 59 104 |
| Total | 163 | |
| Case 3 | Use the Teradata Parallel Data Pump utility to load rows into a base table with a join index | 25,896 |