Query Plan Information and Structure

Depending on the query and database schema, EXPLAIN output includes the following information:

Example

In the EXPLAIN output that follows, the optimizer processes a query in three steps, where each step identified by a unique path ID:

Note: A storage access operation can scan more than the columns in the SELECT list— for example, columns referenced in WHERE clause.