This command is used to list all secondary index tables in the CarbonData table.
SHOW INDEXES ON db_name.table_name;
Parameter |
Description |
|---|---|
db_name |
Database name. It consists of letters, digits, and special characters (_). |
table_name |
Name of the database table. It consists of letters, digits, and special characters (_). |
db_name is optional.
SHOW INDEXES ON productsales.product;
All index tables and corresponding index columns in a given CarbonData table will be listed.