ENG: | How do I know which indexes are used constraint Oracle |
Запрос показывает связь между ограничением и индексом
SELECT o1.object_name "Таблица", c.name "Ограничение", o.object_name "Индекс" FROM con$ c, cdef$ d,dba_objects o,dba_objects o1 WHERE c.name = 'ENT_ARCH_ID_UK' AND c.con# = d.con# AND o.object_id = d.enabled AND d.obj# = o1.object_id;