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.