Statistic.Update 方法

定義

命名空間:

Microsoft.SqlServer.Management.Smo

組件:

Microsoft.SqlServer.Smo.dll

套件:

Microsoft.SqlServer.SqlManagementObjects v172.64.0

多載

名稱	Description
Update()	更新統計數據
Update(StatisticsScanType)	更新統計數據 <param name=“scanType”> 決定掃描類型（FullScan、百分比樣本、列樣本、重取樣）</param>
Update(StatisticsScanType, Int32)	更新統計數據 <param name=“scanType”> 決定掃描類型（FullScan、Percent Sample、Rows Sample、Resample）</param><param name=“sampleValue”> 決定取樣<或參數的百分比或列>
Update(StatisticsScanType, Int32, Boolean)	更新統計數據 <param name=“scanType”> 決定掃描類型（FullScan、Percent Sample、Rows Sample、Resample）</param><param name=“sampleValue”> 決定取樣<百分比或列數/param param><name=“recompute”> 決定是否啟用<自動統計更新/param>

Update()

更新統計數據

public void Update();

member this.Update : unit -> unit

Public Sub Update ()

Update(StatisticsScanType)

更新統計數據

<param name=“scanType”> 決定掃描類型（FullScan、百分比樣本、列樣本、重取樣）</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)

參數

scanType

StatisticsScanType

Update(StatisticsScanType, Int32)

更新統計數據

<param name=“scanType”> 決定掃描類型（FullScan、Percent Sample、Rows Sample、Resample）</param><param name=“sampleValue”> 決定取樣<或參數的百分比或列>

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)

參數

scanType

StatisticsScanType

sampleValue

Int32

Update(StatisticsScanType, Int32, Boolean)

更新統計數據

<param name=“scanType”> 決定掃描類型（FullScan、Percent Sample、Rows Sample、Resample）</param><param name=“sampleValue”> 決定取樣<百分比或列數/param param><name=“recompute”> 決定是否啟用<自動統計更新/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)

參數

scanType

StatisticsScanType

sampleValue

Int32

recompute

Boolean