[ MYSQL ] 인덱스 확인 방법

인덱스 확인

  SHOW INDEX FROM USER_POINT;

 

결과

Table     |Non_unique|Key_name           |Seq_in_index|Column_name        |Collation|Cardinality|Sub_part|Packed|Null|Index_type|Comment|Index_comment|Visible|Expression|
----------+----------+-------------------+------------+-------------------+---------+-----------+--------+------+----+----------+-------+-------------+-------+----------+
USER_POINT|         0|PRIMARY            |           1|user_point_id      |A        |       2203|        |      |    |BTREE     |       |             |YES    |          |
USER_POINT|         0|unique_user_invoice|           1|user_id            |A        |       1548|        |      |    |BTREE     |       |             |YES    |          |
USER_POINT|         0|unique_user_invoice|           2|invoice_id         |A        |       1815|        |      |YES |BTREE     |       |             |YES    |          |
USER_POINT|         0|unique_user_invoice|           3|user_point_provider|A        |       2122|        |      |    |BTREE     |       |             |YES    |          |