134
122

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

MySQLでインデックスが貼られているかを確認するSQL

Last updated at Posted at 2014-08-14

MySQL で index が貼られているか SQL を使って確認します。

indexを確認

indexを確認するコマンド
show index from テーブル名;

例えば log という名前のテーブルの index を確認する場合です。

indexを確認する例
show index from log;

log テーブルに貼られている index が表示されます。

おまけ

indexを追加したり削除する場合です。
http://qiita.com/pugiemonn/items/8a6b322654aa65e2966b

134
122
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
134
122

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?