UPDATE STATISTICS (U-SQL)
Updated: March 10, 2017
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 |
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, unlessIF EXISTSis 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 theINCREMENTALoption is set toON, 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 toOFF, 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;