TableViewBase.UpdateStatistics Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| UpdateStatistics() |
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table. |
| UpdateStatistics(StatisticsTarget, StatisticsScanType) |
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table. |
| UpdateStatistics(StatisticsTarget, StatisticsScanType, Int32) |
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table. |
| UpdateStatistics(StatisticsTarget, StatisticsScanType, Int32, Boolean) |
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table. |
UpdateStatistics()
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table.
public void UpdateStatistics ();member this.UpdateStatistics : unit -> unitPublic Sub UpdateStatistics ()Applies to
UpdateStatistics(StatisticsTarget, StatisticsScanType)
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table.
public void UpdateStatistics (Microsoft.SqlServer.Management.Smo.StatisticsTarget affectType, Microsoft.SqlServer.Management.Smo.StatisticsScanType scanType);member this.UpdateStatistics : Microsoft.SqlServer.Management.Smo.StatisticsTarget * Microsoft.SqlServer.Management.Smo.StatisticsScanType -> unitPublic Sub UpdateStatistics (affectType As StatisticsTarget, scanType As StatisticsScanType)Parameters
- affectType
- StatisticsTarget
- scanType
- StatisticsScanType
Applies to
UpdateStatistics(StatisticsTarget, StatisticsScanType, Int32)
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table.
public void UpdateStatistics (Microsoft.SqlServer.Management.Smo.StatisticsTarget affectType, Microsoft.SqlServer.Management.Smo.StatisticsScanType scanType, int sampleValue);member this.UpdateStatistics : Microsoft.SqlServer.Management.Smo.StatisticsTarget * Microsoft.SqlServer.Management.Smo.StatisticsScanType * int -> unitPublic Sub UpdateStatistics (affectType As StatisticsTarget, scanType As StatisticsScanType, sampleValue As Integer)Parameters
- affectType
- StatisticsTarget
- scanType
- StatisticsScanType
- sampleValue
- Int32
Applies to
UpdateStatistics(StatisticsTarget, StatisticsScanType, Int32, Boolean)
forces data distribution statistics update for a referenced index or all indexes defined on a SQL Server table.
public void UpdateStatistics (Microsoft.SqlServer.Management.Smo.StatisticsTarget affectType, Microsoft.SqlServer.Management.Smo.StatisticsScanType scanType, int sampleValue, bool recompute);member this.UpdateStatistics : Microsoft.SqlServer.Management.Smo.StatisticsTarget * Microsoft.SqlServer.Management.Smo.StatisticsScanType * int * bool -> unitPublic Sub UpdateStatistics (affectType As StatisticsTarget, scanType As StatisticsScanType, sampleValue As Integer, recompute As Boolean)Parameters
- affectType
- StatisticsTarget
- scanType
- StatisticsScanType
- sampleValue
- Int32
- recompute
- Boolean