Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

OptimizedState Element (ASSL)


Applies To: SQL Server 2016 Preview

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


Data type and lengthString (enumeration)
Default valueFullyOptimized
Cardinality0-1: Optional element that can occur once and only once.
Parent elementCubeHierarchy
Child elementsNone

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

FullyOptimizedThe instance builds indexes for the hierarchy to improve query performance.
NotOptimizedThe 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.

Properties (ASSL)

Community Additions

© 2016 Microsoft