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)