When you use showplan, Adaptive Server displays the optimized plan for a given query before it runs the query. When the query plan involves parallel processing, and a runtime adjustment is made, showplan displays this message, followed by the adjusted query plan:
AN ADJUSTED QUERY PLAN WILL BE USED FOR STATEMENT 1 BECAUSE NOT ENOUGH WORKER PROCESSES ARE AVAILABLE AT THIS TIME.
Adaptive Server does not attempt to execute a query when the set noexec is in effect, so runtime plans are never displayed while using this option.
