a unique name that
you specify. This value names the Teradata macro that PreFetch creates
to store selected SQL statements in the first run of a job. During
subsequent runs of the job, SAS/ACCESS presubmits the stored SQL statements
in parallel to the Teradata DBMS.
#sessions
controls the number
of statements that PreFetch submits in parallel to Teradata. A valid
value is 1 through 9. If you do not specify a #sessions value,
the default is 3.
algorithm
specifies the algorithm
that PreFetch uses to order the selected SQL statements. SEQUENTIAL
is currently the only valid value.
Details
Before using PreFetch,
see the description for it in the Teradata section for more detailed
information. This information includes when and how the option enhances
read performance of a job that is run more than once.