Inspect indexes on a table

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.

Same sheet · prioritizing indexes

Add an index for a frequently filtered column.

Open In sheetsqlsame section

Index multiple columns in left-to-right order.

Open In sheetsqlsame section

Remove an index that is unused or harmful.

Open In sheetsqlsame section

View the optimizer's execution plan.

Execute the query and include actual timing information.

Update optimizer statistics for a table.