Changes to Abstract Plans

Adaptive Server 15.0.1 provides enhancements to abstract plans.

• New Query-Level Settings
  The abstract plan syntax, used by Adaptive Server Enterprise to force the query plan chosen by the optimizer, has been extended to allow several query level setting that were previously available only at the session level.
• Operator Name Alignment for the Abstract Plan and the Optimizer Criteria
  Adaptive Server accepts both the h_join and hash_join keywords in abstract plans.
• Extending the Optimizer Criteria Set Syntax
  The set command supports the opt criteria parameter to turn on and off the current optimization goal setting.