AggregationDesign Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines a set of aggregation definitions that can be shared across multiple partitions in a database.

  
<AggregationDesigns>  
   <AggregationDesign>  
      <ID>...</ID>  
      <Name>...</Name>  
            <Description>...</Description>  
      <EstimatedRows>...</EstimatedRows>  
      <Dimensions>...</Dimensions>  
            <Aggregations>...</Aggregation>  
      <EstimatedPerformanceGain>...</EstimatedPerformanceGain>  
      <Annotations>...</Annotations>  
   </AggregationDesign>  
</AggregationDesigns>  

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
RelationshipElement
Parent elementsAggregationDesigns
Child elementsAggregations, Annotations, Description, Dimensions, EstimatedPerformanceGain, EstimatedRows, ID, Name

The corresponding element in the Analysis Management Objects (AMO) object model is AggregationDesign.

Partition Element (ASSL)
Aggregation Element (ASSL)
Aggregations Element (ASSL)
Objects (ASSL)

Community Additions

ADD
Show: