SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > [NO]QEP [CONCISE | SEGMENTED]
Was this helpful?
[NO]QEP [CONCISE | SEGMENTED]
The SET QEP statement displays a diagrammatic representation of the query execution plan chosen for the query by the optimizer. The SET NOQEP option disables this option.
SET QEP CONCISE displays the QEP in a format that is suitable for parsing by a program.
SET QEP SEGMENTED displays QEP as a series of segments that are easier to read when parsing complex SQL statements.
For a discussion of query execution plans, see the Database Administrator Guide.
Last modified date: 04/03/2024