JAEN

SQL

SHOW INDEX

SafeInspect indexes

SHOW INDEX FROM <table>;

Shows indexes and cardinality — when EXPLAIN says full scan, check whether a usable index even exists.

Examples

  • SHOW INDEX FROM orders;Index columns and stats

Syntax

SHOW INDEX FROM table; / \d table(psql)

Before you run it

Read only.

Related commands

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store