Chapter 14: Using Batches and Control-of-Flow Language

Optimizer and partition information stored in global variables

These global variables report on optimization and partition information for Adaptive Server version 15 and later.

**Table 14-10: Global variables containing optimizer and partitioning information**
Global variable	Description
@@optgoal	Returns the current optimization goal setting for query optimization.
@@opttimeout	Returns the current optimization timeout limit setting for query optimization.
@@repartition_degree	Returns the current dynamic repartitioning degree setting.
@@resource_granularity	Returns the maximum resource usage hint setting for query optimization.