SQL Reference Guide > SQL Statements > SET > [NO]OPTIMIZEONLY
Was this helpful?
[NO]OPTIMIZEONLY
OPTIMIZEONLY specifies whether query execution should halt after the completion of query optimization.
Use SET OPTIMIZEONLY in conjunction with SET QEP when there is a requirement to view query execution plans without executing a query.
Last modified date: 01/27/2026