Documentation IndexFetch the complete documentation index at: /llms.txtUse this file to discover all available pages before exploring further.
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Use the SHOW INDEXES command to view indexes from a particular table.
SHOW INDEXES
SHOW INDEXES FROM table_name [ LIKE_expression ];
t3
idx1
CREATE TABLE IF NOT EXISTS t3 ( v1 int, v2 int, v3 int); CREATE INDEX idx1 ON t3 (v1,v2);
SHOW INDEXES FROM t3;
Name | On | Key | Include | Distributed By ------+----+----------------+---------+---------------- idx1 | t3 | v1 ASC, v2 ASC | v3 | v1, v2 (1 row)
Was this page helpful?
