After an export is defined (see Export Options), Teradata SET can be used to estimate how long it will take to run the export operation. If the estimate is high, the export parameters can be defined or the operation can be run at a more convenient time.
The estimate-time function is available for all export methods. Specific privileges and a connection to the database are required. See Estimate-Time Rights.
- Go to one of the following:
- Export by Query dialog box
- Exporting by Database dialog box
- Exporting by Workload dialog box
- Click Estimate Time.
The Estimated Time dialog box appears and displays time estimates for each object being exported plus a total estimated time for the export operation.
- Click Refresh to view estimates of the time needed to export each object.
- Click OK to close the Estimated Time dialog box.
- [Optional] When exporting by query, a query can be removed or the estimated time for a selected query or queries can be viewed:
- Under Selected Queries, right-click the row.
- Select a command from the shortcut menu.
- Under Selected Queries, right-click the row.