8. SQL Statements : SET : [No]Optimizeonly
 
Share this page                  
[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.