all foreign key should have index?

From: "Murtuja" <Murtuja.Khokhar@xxxxxxxxx>
Date: 30 Jan 2006 05:51:41 -0800

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?

.

Follow-Ups:
- Re: all foreign key should have index?
  - From: -CELKO-

Prev by Date: Re: Reminder, blatant ad
Next by Date: Re: Why not many2one with pk array type
Previous by thread: Rqst for Inventory Database Best Practices
Next by thread: Re: all foreign key should have index?
Index(es):
- Date
- Thread