PREFETCH= LIBNAME Option

Enables the PreFetch facility on tables that the libref (defined with the LIBNAME statement) accesses.
Valid in: SAS/ACCESS LIBNAME statement
Default: not enabled
Data source: Teradata
See: Using the PreFetch Facility

Syntax

PREFETCH='unique_storename, [#sessions,algorithm]'

Syntax Description

unique_storename
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.