Share via


TableViewBase.UpdateStatistics Method (StatisticsTarget, StatisticsScanType)

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

Examples

Working with Database Objects

See Also

Reference

TableViewBase Class

UpdateStatistics Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

Views

CREATE TABLE (Transact-SQL)

CREATE VIEW (Transact-SQL)

UPDATE STATISTICS (Transact-SQL)