Share via

OptimizedState Element (ASSL)

  • Article

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

Syntax

<CubeHierarchy>
   ...
   <OptimizedState>...</OptimizedState>
   ...
</CubeHierarchy>

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

Remarks

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

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance