Foreign Keys and Indexes

I was surprised to find that when I created a foreign key on a field in a child table that access to that table through the key hadn't improved.

Do I have to also create an index on the same field? Why can't Oracle use the implied index created for the foreign key? Seems like a waste to have to create a "second" index on the same field.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet