Kontrola indexů

Chybějící

SELECT rel.RDB$RELATION_NAME AS TABLE_NAME FROM RDB$RELATIONS rel 
WHERE COALESCE(rel.RDB$SYSTEM_FLAG, 0) = 0 AND COALESCE(rel.RDB$RELATION_TYPE,0) = 0
AND NOT EXISTS (SELECT ind.RDB$INDEX_NAME FROM RDB$INDICES ind WHERE RDB$UNIQUE_FLAG=1 AND ind.RDB$RELATION_NAME=rel.RDB$RELATION_NAME)
AND NOT (rel.RDB$RELATION_NAME='COMMON_SYSLOG' OR rel.RDB$RELATION_NAME='PROST_KAPACITY'  OR rel.RDB$RELATION_NAME='DOKUMENTY_CPOPIS' OR rel.RDB$RELATION_NAME LIKE '%CISMEMO%')

Seznam všech

SELECT rel.RDB$RELATION_NAME as TABLE_NAME, ind.RDB$INDEX_NAME AS INDEX_NAME, cast(list(trim(seg.RDB$FIELD_NAME)) as varchar(1024)) as INDEX_FIELDS  FROM RDB$RELATIONS rel 
join RDB$INDICES ind on RDB$UNIQUE_FLAG=1 and ind.RDB$RELATION_NAME=rel.RDB$RELATION_NAME
join RDB$INDEX_SEGMENTS seg on ind.RDB$INDEX_NAME=seg.RDB$INDEX_NAME
WHERE COALESCE(rel.RDB$SYSTEM_FLAG, 0) = 0 AND coalesce(rel.RDB$RELATION_TYPE,0) = 0
group by 1,2