Definitions for "Access plan"
A plan generated by the database engine to execute an SQL statement. Equivalent to executable code compiled from a third-generation language such as C.
The set of access paths that are selected by the optimizer to evaluate a particular SQL statement. The access plan specifies the order of operations to resolve the execution plan, the implementation methods (such as JOIN), and the access path for each table referenced in the statement.
In DB2 UDB for iSeries, the control structure produced during compile time that is used to process SQL statements encountered when the program is run.