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.
Summary
In order to provide more information to the query optimizer about the data characteristics stored inside a table, such as the value distribution etc., U-SQL provides statistics on the tables. For most queries, the query optimizer already generates the necessary statistics for a high-quality query plan; in a few cases, you need to create additional statistics with CREATE STATISTICS or modify the query design to improve query performance.
Statistics DDL Statements
The following statements are supported:
Syntax
Statistics_DDL_Statement :=
Create_Statistics_Statement
| Update_Statistics_Statement
| Drop_Statistics_Statement.