Skip to end of metadata
Go to start of metadata


Displays explain plans for a query, same information from the studio explain plan

Input Parameters


Output Parameters

STMT_IDENTIFIER: Identifiert for SQL statement (statement name or if not statement name defined timestamp of explain)
LINE_ID:         Line number of the explain plan
OPERATION:       Explain plan operation
TABLE_NAME:      Table name
ESTIMATED_COSTS: Estimated costs for explain plan step (including sub-steps)
ESTIMATED_ROWS:  Estimated rows
ENGINE:          Engine used for processing the explain plan operation
HOST:            Host name on which the explain plan operation is processed

  • No labels