Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Updates the statistics for the table or view with the option to specify the target and the type of scan performed.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub UpdateStatistics ( _
affectType As StatisticsTarget, _
scanType As StatisticsScanType _
)
'Usage
Dim instance As TableViewBase
Dim affectType As StatisticsTarget
Dim scanType As StatisticsScanType
instance.UpdateStatistics(affectType, _
scanType)
public void UpdateStatistics(
StatisticsTarget affectType,
StatisticsScanType scanType
)
public:
void UpdateStatistics(
StatisticsTarget affectType,
StatisticsScanType scanType
)
member UpdateStatistics :
affectType:StatisticsTarget *
scanType:StatisticsScanType -> unit
public function UpdateStatistics(
affectType : StatisticsTarget,
scanType : StatisticsScanType
)
Parameters
- affectType
Type: Microsoft.SqlServer.Management.Smo.StatisticsTarget
A StatisticsTarget object value that specifies the target of the statistics update, such as columns or indexes.
- scanType
Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType
A StatisticsScanType object value that specifies the way in which statistical information is gathered.
Examples
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace