Update Statistics Hist Template
Overview
Update Statistics Hist Template is a SQL Templates parameter that controls the pattern used to create an UPDATE STATISTICS statement in the historizing stored procedure. {TableName} can be used as an alias.
Function
Use this setting to keep generated SQL execution consistent across the project. AnalyticsCreator uses this value when no custom value is saved for the project. Keep placeholder names unchanged when adapting the pattern.
This value supports placeholders such as {TableName}.
Access
The parameter is maintained from the Parameters list in AnalyticsCreator.
How to access
Navigation tree
Parameters->List Parameters
Toolbar
Options->Parameter
Diagram
Not opened from the diagram.
Visual element
Parameter list
Default value
UPDATE STATISTICS {TableName}
Custom value
Not set.
Where it is used
This parameter belongs to the SQL Templates group and is used when AnalyticsCreator applies generated SQL execution.
| Setting | Value |
|---|---|
| Technical parameter name | UPDATE_STATISTICS_HIST_TEMPLATE |
| Default value | UPDATE STATISTICS {TableName} |
| Custom value | Not set. |
Parameter groups
| Group |
|---|
| SQL Templates |
| SQL Variables |
| SQL |
