Multiple choice technology databases

A Plan

  1. Is an executable module containing access path logic provided by the DB2 optimiser

  2. In an non executable module containing access path logic provide by the DB2 optimiser

  3. Is just a module containing access path to DB2 optimiser

  4. Is a module containing access path

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Plan in DB2 is an executable module containing the access path logic determined by the DB2 optimizer. When you bind a plan, DB2 generates optimized access paths for SQL statements, which are stored in the plan and executed at runtime.