View Index Details

Description

DESC INDEX queries the creation date and name of the index

Syntax

DESC INDEX [EXTENDED] index_name;

Parameter Description

• index_name: The name of the index to view.
• EXTENDED: Allows viewing more extended information about the index, such as the size of the inverted index. Currently, viewing the size of the BLOOMFILTER index is not supported.

Usage Example

Example 1: View details of the index named idx_users_email

DESC INDEX EXTENDED order_year_index;
+--------------------------+--------------------------+
|        info_name         |        info_value        |
+--------------------------+--------------------------+
| name                     | order_year_index         |
| creator                  | UAT_TEST                 |
| created_time             | 2024-12-27 10:51:58.977  |
| last_modified_time       | 2024-12-27 10:51:58.977  |
| comment                  |                          |
| properties               | (("analyzer","chinese")) |
| index_type               | inverted                 |
| table_name               | t                        |
| table_column             | order_year               |
| index_size_in_data_file  | 0                        |
| index_size_in_index_file | 296                      |
| total_index_size         | 296                      |
+--------------------------+--------------------------+