ProcessOptimizationMode (MDStore Interface)


  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The ProcessOptimizationMode property of the MDStore interface indicates whether the Analysis server indexes and aggregates during or after processing.

Applies To: clsCube, clsPartition


This property can be used to expedite the availability of a cube or partition to users for analysis. By default, the processOptimizationModeRegular option specifies that the cube's source data is read, stored, indexed, and aggregated within the processing transaction. The processOptimizationModeLazyOptimizations option reads and stores the source data during the processing transaction and performs lazy processing of indexes and aggregations after processing is complete, when the Analysis server is idle.

By default, this property applies to the entire cube. However, it can be overridden by the value for this property for the individual partitions of the cube.

Community Additions