API Definition
REPLACE PROCEDURE tdstats.UpdateHistogramSettingsJSON (IN jIn JSON(3000) CHARACTER SET UNICODE, OUT jOut JSON(3000) CHARACTER SET UNICODE)
JSON Keys
| JSON Key | IN/OUT | Data Type | Description |
|---|---|---|---|
| SCOID | IN | BIGINT | AutoStats assigned identifier of an individual statistic whose settings are to be changed. |
| DatabaseName | IN | VARCHAR(128) | Apply the new settings to all statistics collected within the specified database. |
| TableName | IN | VARCHAR(128) | Apply the new settings to an individual table residing within the specified DatabaseName. |
| MaxIntervals | IN | INTEGER | Value to specify for the MAXINTERVALS option for generated COLLECT STATISTICS statements. Allowable values are 0 to 500. A value of -1 indicates the SYSTEM selected value is used. |
| MaxLength | IN | INTEGER | Value to specify for the MAXVALUELENGTH option for generated COLLECT STATISTICS statements. A value of -1 indicates the SYSTEM selected value is used. |
| NumUpdated | OUT | INTEGER | Number of statistics whose settings have been updated. |