Statistic.Update 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
Update() |
Updates the statistic |
Update(StatisticsScanType) |
Updates the statistic <param name="scanType">determines the type of scan (FullScan, Percent Sample, Rows Sample, Resample)</param> |
Update(StatisticsScanType, Int32) |
Updates the statistic <param name="scanType">determines the type of scan (FullScan, Percent Sample, Rows Sample, Resample)</param><param name="sampleValue">determines percent or rows to sample</param> |
Update(StatisticsScanType, Int32, Boolean) |
Updates the statistic <param name="scanType">determines the type of scan (FullScan, Percent Sample, Rows Sample, Resample)</param><param name="sampleValue">determines percent or rows to sample</param><param name="recompute">determines whether automatic statistics update is enabled</param> |
Update()
Updates the statistic
public void Update();
member this.Update : unit -> unit
Public Sub Update ()
Applies to
Update(StatisticsScanType)
Updates the statistic
<param name="scanType">determines the type of scan (FullScan, Percent Sample, Rows Sample, Resample)</param>public void Update(Microsoft.SqlServer.Management.Smo.StatisticsScanType scanType);
member this.Update : Microsoft.SqlServer.Management.Smo.StatisticsScanType -> unit
Public Sub Update (scanType As StatisticsScanType)
Parameters
- scanType
- StatisticsScanType
Applies to
Update(StatisticsScanType, Int32)
Updates the statistic
<param name="scanType">determines the type of scan (FullScan, Percent Sample, Rows Sample, Resample)</param><param name="sampleValue">determines percent or rows to sample</param>public void Update(Microsoft.SqlServer.Management.Smo.StatisticsScanType scanType, int sampleValue);
member this.Update : Microsoft.SqlServer.Management.Smo.StatisticsScanType * int -> unit
Public Sub Update (scanType As StatisticsScanType, sampleValue As Integer)
Parameters
- scanType
- StatisticsScanType
- sampleValue
- Int32
Applies to
Update(StatisticsScanType, Int32, Boolean)
Updates the statistic
<param name="scanType">determines the type of scan (FullScan, Percent Sample, Rows Sample, Resample)</param><param name="sampleValue">determines percent or rows to sample</param><param name="recompute">determines whether automatic statistics update is enabled</param>public void Update(Microsoft.SqlServer.Management.Smo.StatisticsScanType scanType, int sampleValue, bool recompute);
member this.Update : Microsoft.SqlServer.Management.Smo.StatisticsScanType * int * bool -> unit
Public Sub Update (scanType As StatisticsScanType, sampleValue As Integer, recompute As Boolean)
Parameters
- scanType
- StatisticsScanType
- sampleValue
- Int32
- recompute
- Boolean