Share via


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.

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace