all foreign key should have index?

Is it necessary that all foreign key should have index?

SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE = 'R' AND INDEX_NAME IS NOT NULL Above query does not return any row in my database.Is it bad? Received on Mon Jan 30 2006 - 07:51:41 CST