API Definition
REPLACE PROCEDURE TDStats.ApproveStatJSON(
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 unique numeric identifier for an individual missing statistic recommendation. |
| DatabaseName |
IN |
VARCHAR(128) |
Approve all statistics defined on the specified database. |
| TableName |
IN |
VARCHAR(128) |
Further limit the approval to the statistics defined on a specified table of DatabaseName. |
| ObjectListName |
IN |
VARCHAR(128) |
Specifies a previously defined list of objects whose missing statistics recommendations should be approved. See related API "CreateObjectList" in ObjectList APIs Syntax. |
| NumApproved |
OUT |
INTEGER |
Number of approved statistics that were previously unapproved. |