Changes to Abstract Plans

Adaptive Server 15.0.1 provides enhancements to abstract plans.

The enhancements include:

  • The abstract plan syntax has been extended to allow several query level setting that were previously available only at the session level.
  • Adaptive Server accepts both the h_join and hash-join keywords in the extended abstract plan syntax.
  • The set command supports the opt criteria parameter to turn on and off the current optimization goal setting.