O'Reilly logo

Microsoft Azure SQL Data Warehouse - Architecture and SQL by Todd Wilson, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5 – CREATE Statistics

“Every sunrise is a second chance.”

- Unknown

CREATE Statistics Syntax

CREATE STATISTICS statistics_name

ON [ database_name . [schema_name ] . | schema_name. ] table_name

( column_name  [ ,...n ] )

[ WHERE <filter_predicate> ]

[ WITH {

FULLSCAN

| SAMPLE number PERCENT

}

] [;]

image

The CREATE Statistics command will create statistics for a column(s) on a table that is designed to help the query optimizer by providing statistics about the Azure SQL Data Warehouse table. The statistics provide the Control node with important information to improve the query plan for data movement operations, and the Compute nodes use the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required