목록index (1)

Binary Journey

[MariaDB] 존재하는 인덱스 모두 조회 (SELECT ALL INDEXES)

철수 전 기록 남기기 - 1. SELECT INDEX_SCHEMA , INDEX_NAME , GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) AS INDEX_COLUMNS , INDEX_TYPE , CASE NON_UNIQUE WHEN 1 THEN 'NON_UNIQUE' ELSE 'UNIQUE' END AS IS_UNIQUE , TABLE_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA NOT IN ('INFORMATION_SCHEMA', 'MYSQL', 'PERFORMANCE_SCHEMA', 'SYS') AND INDEX_NAME NOT IN ('PRIMARY') GR..
MySQL | MariaDB 2024. 5. 16. 16:43
이전 Prev 1 Next 다음