Outdated Version
You are viewing an older version of this section. View current production version.
SHOW INDEX
Show the list of indexes associated with a given table.
Syntax
SHOW INDEX
{FROM | IN} tbl_name
[{FROM | IN} db_name]
[WHERE expr]
Remarks
tbl_name- name of a table in a MemSQL database.db_name- name of a MemSQL database. If not specified, then the currently open database is used.expr- SQL WHERE expression.- This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands).
Output
| Column | Description |
|---|---|
Table |
Table name |
Non_unique |
Non-unique |
Key_name |
Key name |
Seq_in_index |
Sequence in the index |
Column_name |
Column name |
Collation |
Collation |
Cardinality |
Cardinality |
Sub_part |
Sub-part |
Packed |
Packed |
Null |
Null |
Index_type |
Index type (see Index) |
Comment |
Comment |
Index_comment |
Comment |
Example
memsql> SHOW INDEX IN mytbl;
+-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| mytbl | 1 | seq | 1 | seq | NULL | NULL | NULL | NULL | YES | BTREE | | |
| mytbl | 1 | seq_index | 1 | seq | NULL | NULL | NULL | NULL | YES | BTREE | | |
+-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.00 sec)
