Oracle Database Discussions

HI ,

I run the following query to found the foreign key columns that are not indexed :

SELECT c.owner, c.table_name, c.constraint_name
, c.r_owner, c.r_constraint_name
, r.table_name r_table_name
FROM all_constraints c
, all_constraints r
WHERE c.constraint_Type = 'R'
AND r.owner = c.r_owner
AND r.constraint_name = c.r_constraint_name
AND r.constraint_Type = 'P'

When I Created the indexes on the columns given by the query but this query still shows me the same columns to create indexes which I had already did it.


Thank you for helping me out.


Kind Regards,

Adnan Hamdus Salam