U-SQL Statistics

Updated: March 10, 2017

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.  

See Also

• Data Definition Language (DDL) Statements (U-SQL)