테이블 인덱스 - DBMS별 확인 방법: Revision history

From IT Wiki

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

    2 September 2022

    • curprev 13:2013:20, 2 September 2022‎ Dbeaver talk contribs‎ 806 bytes +806‎ 새 문서: * 상위 문서: 테이블 인덱스 == PostgreSQL == === 인덱스 확인 === pg_indexes 테이블 활용<blockquote>SELECT * FROM pg_indexes WHERE tablename = 'mytable';</blockquote> === 인덱스 통계 확인 === pg_stat_user_indexes 테이블 활용<syntaxhighlight lang="sql" line="1"> SELECT schemaname AS schema_name, relname AS table_name, indexrelname AS index_name, pg_size_pretty(pg_relation_size(indexrelid::regclass)) AS index_size, idx_scan... Tag: Visual edit
Retrieved from "https://itwiki.kr/w/테이블_인덱스_-_DBMS별_확인_방법"