Re: FK-constraints without corresponding index, how to find with SQL ?

Jonathan Lewis wrote re foreign key constraints and indexes on matching columns:

"Although the index can have extra columns tagged on to the end, the columns that match the foreign key constraint have to be in the right order."

Interestingly enough, with some versions of Oracle it is possible to create constraints and indexes that whose orders do not match. You should avoid doing so however. Symptoms include irrelevant (even more so than usual) error messages if you try to select from the table - "error in recursive SQL level 1... etc."

---
Paul Kelley