Viewing an execution plan

Use Interactive SQL to display an UltraLite plan that summarizes how a prepared statement is to be executed. The text plan
is displayed in the Interactive SQL Plan Viewer.

Prérequis

There are no prerequisites for this task.

Contexte et remarques

In UltraLite, an execution plan is strictly a short textual summary of the plan. No other plan types are supported. However,
being a short plan, it allows you to compare plans quickly, because information is summarized on a single line.

The plan indicates that the join operation is completed by reading all rows from the Invoice table (following an index named
primary). It then uses the index named secondary from the Transactions table to read only the row whose inv_no column matches.