Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set SQL Options
Select Optimize SQL | SQL Rewrite | SQL Options
Review the following for additional information:
Specify whether to set the current degree of intra-partition parallelism. Note the following:
|Set Value for the "Optimize for" Option||Specify the number of rows to optimize. If this option is not selected, then it is assumed that all rows will be retrieved.|