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.