Méthode Index.UpdateStatistics (StatisticsScanType, Int32)
Updates statistics for the referenced index with the specified statistics scan type and specified sample size.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Sub UpdateStatistics ( _
scanType As StatisticsScanType, _
sampleValue As Integer _
)
'Utilisation
Dim instance As Index
Dim scanType As StatisticsScanType
Dim sampleValue As Integer
instance.UpdateStatistics(scanType, sampleValue)
public void UpdateStatistics(
StatisticsScanType scanType,
int sampleValue
)
public:
void UpdateStatistics(
StatisticsScanType scanType,
int sampleValue
)
member UpdateStatistics :
scanType:StatisticsScanType *
sampleValue:int -> unit
public function UpdateStatistics(
scanType : StatisticsScanType,
sampleValue : int
)
Paramètres
- scanType
Type : Microsoft.SqlServer.Management.Smo.StatisticsScanType
A StatisticsScanType the method used to update the statistics.
- sampleValue
Type : System.Int32
An Int32 value that specifies the sample size.
Notes
[!REMARQUE]
Indexes based partly on the UserDefinedTableType object do not support statistics and running this method will generate an exception.
Exemples
Création, modification et suppression d'index
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo