Table of contents
TOC
Collapse the table of content
Expand the table of content

U-SQL Statistics

Michael Rys|Last Updated: 5/15/2018
|
4 Contributors

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

© 2018 Microsoft