Check if there are tables that contain foreign keys that don't have an index yet

UnindexedForeignKeys.sql

         select /*+ first_rows */ 
           c.owner
         , c.table_name
         , c.constraint_name
         from 
           user_constraints c
         where not exists
         ( select 1
           from
             user_cons_columns cc
           , user_ind_columns ic
           where cc.table_name=c.table_name
           and   cc.constraint_name=c.constraint_name
           and   cc.table_name=ic.table_name
           and   cc.column_name = ic.column_name
         )
       and   c.constraint_type = 'R';