Statistics

Statistics#

Statistics describe the distribution of values in columns and help the query planner choose efficient plans. Querona lets you create statistics explicitly and refresh them.

CREATE STATISTICS#

Creates statistics on one or more columns of a table.

CREATE STATISTICS statistics name ON table ( columns )

UPDATE STATISTICS#

Refreshes the statistics for a table.

UPDATE STATISTICS table options

Examples#

CREATE STATISTICS Product_Price ON dbo.Product (Price);

UPDATE STATISTICS dbo.Product;