With a table argument it shows that table's indexes; without one, all indexes in the database. Indexes speed lookups but slow writes. Related: CREATE INDEX.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.