6. QUEL and EQUEL Statements : Set Statement--Set Session Options : Description : Set [no]optimizeonly Option
 
Share this page                  
Set [no]optimizeonly Option
This statement specifies whether query execution halts after the optimization phase. To halt execution after the query has been optimized, specify set optimizeonly; to continue query execution after the query is optimized, specify set nooptimizeonly. To view query execution plans (QEP's) without executing a query, use set optimizeonly in conjunction with set qep.