OptimizedState Element (ASSL)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Determines the level of optimization that is applied to the hierarchy.



Element Characteristics

Characteristic Description
Data type and length String (enumeration)
Default value FullyOptimized
Cardinality 0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element
Parent element CubeHierarchy
Child elements None


The value of this element is limited to one of the strings listed in the following table.

Value Description
FullyOptimized The instance builds indexes for the hierarchy to improve query performance.
NotOptimized The instance does not build additional indexes.

The enumeration that corresponds to the allowed values for OptimizedState in the Analysis Management Objects (AMO) object model is OptimizationType.

See Also

Properties (ASSL)