9_Index_Not_Analyzed.sql
select 'Index '||i.index_name||' not analyzed but table '||
i.table_name||' is.'
from dba_tables t, dba_indexes i
where t.table_name = i.table_name
and t.num_rows is not null
and i.distinct_keys is null
/
Nenhum comentário:
Postar um comentário