|
=== 인덱스를 전혀 가지지 않는 테이블 리스트
Doc
Name : IND_0.sql
Author: Mahnho Han
List all tables that do not have any indexes
#
TTITLE 'Report on all tables without indexes'
select owner,table_name
from dba_tables
MINUS
select owner,table_name
from dba_indexes;
=== 인덱스를 5개 이상가지는 테이블의 리스트
Doc
Name: IND_5.sql
Author: Mahnho Han
Tables that has indexes more than 5
#
COLUMN TABLE_NAME FORMAT A30
SELECT TABLE_OWNER,TABLE_NAME,COUNT(*)
FROM DBA_INDEXES
GROUP BY TABLE_OWNER,TABLE_NAME
HAVING COUNT(*) > 5 or COUNT(*) = 0
ORDER BY TABLE_OWNER,TABLE_NAME;
|
