U-SQL Statistics

  • Article

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.

See Also