GET_QUERY_EXECUTION_PLAN¶

Description

The stored procedure GET_QUERY_EXECUTION_PLAN returns the execution plan of the query received as a parameter as text.

Syntax

GET_QUERY_EXECUTION_PLAN (
      input_query : text
)

• input_query (mandatory): query to obtain the execution plan.

The procedure returns one row, with these fields:

• input_query: requested input query.

• execution_plan: execution plan for the requested query.

Privileges Required

This procedure does not require any privilege.

Examples

Example 1

SELECT *
FROM GET_QUERY_EXECUTION_PLAN()
WHERE input_query = 'SELECT * from internet_inc'

This query obtains the execution plan for the requested query.