Methods, clsPartitionAnalyzer

Note

  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.

An object of ClassType clsPartitionAnalyzer implements the following methods.

Method

Description

AddExistingAggregation

Adds an existing aggregation to the DesignedAggregations collection

AddGoalquery

Adds a specific query for the analyzer to optimize

CloseAggregationsAnalysis

Closes the partition analyzer session and clears the objects used during the analysis

InitializeDesign

Checks the partition structure to ensure that the partition analyzer can be run and initializes the objects necessary to perform the analysis

NextAnalysisStep

Adds new aggregations to the DesignedAggregations collection and calculates the incremental performance gain and the additional aggregation storage requirements

PrepareGoalQueries

Prepares the goal queries that were entered using the AddGoalQuery method for use in this analysis session

See Also

Reference