Display index metadata for a table.

Section: indexes

Inspect indexes on a table

sql
sql
SHOW INDEX FROM orders;
Explanation

Review cardinality, uniqueness, and column order when debugging plans.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing indexes
Create a simple index
Add an index for a frequently filtered column.
OpenIn sheetsqlsame section
Create a composite index
Index multiple columns in left-to-right order.
OpenIn sheetsqlsame section
Drop an index
Remove an index that is unused or harmful.
OpenIn sheetsqlsame section
Explain a SELECT query
View the optimizer's execution plan.
Run EXPLAIN ANALYZE
Execute the query and include actual timing information.
Refresh table statistics
Update optimizer statistics for a table.