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:
Statistics_DDL_Statement := Create_Statistics_Statement | Update_Statistics_Statement | Drop_Statistics_Statement.