温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Mysql show index解释

发布时间:2020-07-16 19:30:29 来源:网络 阅读:1954 作者:Abigale2018 栏目:MySQL数据库

查看表上的索引状态:


SHOW INDEX returns table index information.


SHOW KEYS and SHOW INDEXES are synonyms for SHOW INDEX.


语法:


show {index|indexes} from table_name [ from db_name ] [where expr]


The following fields are returned by SHOW INDEX.


FieldDescription
TableTable name
Non_unique1 if the index permits duplicate values, 0 if values must be unique.
Key_nameIndex name. The primary key is always named PRIMARY.
Seq_in_indexThe column's sequence in the index, beginning with 1.
Column_nameColumn name.
CollationEither A, if the column is sorted in ascending order in the index, or NULL if it's not sorted.
CardinalityEstimated number of unique values in the index. The cardinality statistics are calculated at various times, and can help the optimizer make improved decisions.
Sub_partNULL if the entire column is included in the index, or the number of included characters if not.
PackedNULL if the index is not packed, otherwise how the index is packed.
NullNULL if NULL values are permitted in the column, an empty string if NULL's are not permitted.
Index_typeThe index type, which can be BTREE, FULLTEXT, HASH or RTREE. See Storage Engine Index Types.
CommentOther information, such as whether the index is disabled.
Index_commentContents of the COMMENT attribute when the index was created.



    

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI