indexStats
indexStatsInspect index definitions, size, usage, and cardinality counters for a table or schema to evaluate index effectiveness.
Instructions
Inspect index definitions together with operational size, usage and cardinality counters for one table or a schema. Use describeTable for structural metadata of one table without live index statistics.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | Omit to scan the schema. | |
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| indexes | No | Indexes available on the table or returned by an index-statistics scan. |