Job scripts can be constructed to maximize job performance by specifying multiple instances of an operator at the point where the operator is referenced in an APPLY statement. Operator instances then execute in parallel to complete the task.
Each operator used in a single-step job, or in a job step, will attempt to simultaneously log on to one database session for each AMP configured on the database system. This feature provides a high degree of parallelism to maximize operator performance.
The following operators can be configured to enhance job performance through the optimization of instances and sessions:
- DataConnector (instances only)
- Export
- Load
- SQL Inserter
- Stream
- Update
The following sections discuss how to optimize the specification of instances and sessions in a job script.