gather_hg_table_statistics
Execute the ANALYZE TABLE command on Hologres databases to collect table statistics, improving query optimization performance for better query plans.
Instructions
Execute the ANALYZE TABLE command to have Hologres collect table statistics, enabling QO to generate better query plans
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | Yes | Schema name in Hologres database | |
| table | Yes | Table name in Hologres database |
Input Schema (JSON Schema)
{
"properties": {
"schema": {
"description": "Schema name in Hologres database",
"type": "string"
},
"table": {
"description": "Table name in Hologres database",
"type": "string"
}
},
"required": [
"schema",
"table"
],
"type": "object"
}