Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |