API Definition
REPLACE PROCEDURE tdstats.UpdateStatSamplingSettingJSON (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. |
| SampleType | IN | CHAR(1) | Type to use for SAMPLE option for generated COLLECT STATISTICS statements. Valid values are:
|
| Percentage | IN | INTEGER | Value for <percentage> specified in SampleType. Allowable values are 2 to 100. |
| NumUpdated | OUT | INTEGER | Number of statistics whose histogram settings have been updated. |