Improving SQL Task Performance

Previous Next

Poor SQL task performance may be due to excessive rollback segment creation. This happens when large data volumes are processed and the SQL task has a TASK level commit.

Techniques to improve SQL task performance include:

Deactivating certain constraints and relational checks.

Under certain conditions, use set oriented manipulations. Refer to the Rules Engine Help topic: "Set Oriented Manipulations".

Disabling Rules.