FA Database Index Listing - draft

select	ind.table_name,
	ind.index_name,
	obj.created,
	obj.last_ddl_time,
	lu.meaning	unique_flag,
	col.column_name
from	all_indexes ind,
	all_ind_columns col,
	all_objects obj,
	fa_lookups lu
where	ind.table_name like 'FA%'
and	col.table_name = ind.table_name
and	col.index_name = ind.index_name
and	obj.object_name = ind.index_name
and	obj.object_type = 'INDEX'
and	lu.lookup_type = 'YESNO'
and	lu.lookup_code = decode (ind.uniqueness, 'UNIQUE', 'YES', 'NO')
order by
	ind.table_name, ind.index_name, col.column_position

select ind.table_name, ind.index_name, obj.created, obj.last_ddl_time, lu.meaning unique_flag, col.column_name from all_indexes ind, all_ind_columns col, all_objects obj, fa_lookups lu where ind.table_name like 'FA%' and col.table_name = ind.table_name and col.index_name = ind.index_name and obj.object_name = ind.index_name and obj.object_type = 'INDEX' and lu.lookup_type = 'YESNO' and lu.lookup_code = decode (ind.uniqueness, 'UNIQUE', 'YES', 'NO') order by ind.table_name, ind.index_name, col.column_position