Re: Foreign key constraint removes need for index?

johnh..._at_gmail.com wrote:
> If column A has a foreign key constraint with a parent table, then do I
> need to explicitly add an index on column A for performance in queries?

I would. A foreign key does not index the referencing column. You might want to read this thread:

http://asktom.oracle.com/pls/ask/f?p=4950:8:14866950931099969047::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:292016138754

David Fitzjarrell Received on Wed Sep 13 2006 - 16:30:50 CDT