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

UPDATE STATISTICS (U-SQL)

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

U-SQL provides the UPDATE STATISTICS statement to update a previously created statistic on a table.

Syntax
Update_Statistics_Statement :=                                                                           
     'UPDATE' 'STATISTICS' ['IF' 'EXISTS']
     Statistic_Name 'ON' Table_Name'WITH' 'INCREMENTAL' '=' ('ON' | 'OFF').
Statistic_Name := Quoted_or_Unquoted_Identifier.
Table_Name := Identifier.

Semantics of Syntax Elements

  • Statistic_Name ON Table_Name
    Specifies the name (either a quoted or unquoted identifier) of the statistic of the given table to be updated. If the statistic does not exist or the user does not have permissions, then an error is raised, unless IF EXISTS is specified. In that case, if the user has at least enumeration permission on the table, the operation will silently complete without action. If the user has no enumeration permission, an error is raised.

  • WITH INCREMENTAL = 'ON' | 'OFF'
    When the INCREMENTAL option is set to ON, the statistics are updated with the newly inserted data and newly added partitions since the last time the statistic got calculated. If it is set to OFF, the statistics tree is dropped and the full statistic is recomputed.

Example

  • The example can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
  • The script can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.

The following example does a full update of the statistics, ordersStats, within the table Orders in TestReferenceDB.

USE TestReferenceDB;

UPDATE STATISTICS IF EXISTS ordersStats 
ON dbo.Orders
WITH INCREMENTAL = OFF;

See Also

© 2018 Microsoft