DB/MYSQL
[ MYSQL ] 인덱스 확인 방법
HEON.D
2024. 12. 19. 15:29
인덱스 확인
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 | |