SqlStatisticsSamplingStyle Enumeration
Defines the sampling styles that are used to create statistics.
Namespace: Microsoft.Data.Schema.Sql.SchemaModel
Assembly: Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
Syntax
'Declaration
Public Enumeration SqlStatisticsSamplingStyle
public enum SqlStatisticsSamplingStyle
public enum class SqlStatisticsSamplingStyle
type SqlStatisticsSamplingStyle
public enum SqlStatisticsSamplingStyle
Members
| Member name | Description | |
|---|---|---|
| Automatic | Specifies that statistics are updated automatically. | |
| Fullscan | Computes statistics by scanning all rows in the table or indexed view. | |
| SamplePercentRows | Specifies the approximate percentage of rows in the table or indexed view for the query optimizer to use when it creates statistics. | |
| SampleAbsoluteRows | Specifies the approximate number of rows in the table or indexed view for the query optimizer to use when it creates statistics. |