Has anyone every answered this question? This is exactly the issue I
asked about a couple of weeks ago and I got a couple of good responses
that I appreciate but I think I didn't state the question as clearly as
it is here.

"Is the constraint all that I need? Is it used like an index so that
joins
will perform quickly?"

My research has revealed NO and NO to the above 2 questions. Am I right
or wrong?

Thanks!

Jeff

Robb Messer wrote:

> A quick question about Foreign Keys. The database I'm working with
> has both
> a FK constraint and an index for each FK in the database. So for a
> single
> column foreign key between two tables, I have the constraint (CFK_***)
> and
> an index on the FK column (IXF_***).
>
> Tables often have 8 - 10 indexes, plus primary keys and needed unique
> column
> indexes.
>
> Is the constraint all that I need? Is it used like an index so that
> joins
> will perform quickly?