Home > Term: access plan
access plan
(1) The set of access paths that is selected by the query optimizer to evaluate a particular SQL or XQuery 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 that is referenced in the statement.
(2) In DB2 for i5/OS, the control structure produced during compile time that is used to process SQL statements encountered when the program is run.
- Part of Speech: noun
- Industry/Domain: Software
- Category: Globalization software service
- Company: IBM
0
Creator
- Peteh
- 100% positive feedback