Re: Primary Key Constraints vs just indexes

Iain William Wiseman <bibble_at_paradise.net.nz> wrote in news:4297b76e$1_at_clear.net.nz:

> Hi All,
>
> Our goal is to increase performance. We have data on one platform which
> is replicated to a second using custom software.
>
> We know the data on master is always correct as there is referential
> constraints on the Master copy. I.E. Foreign and Primary Key constraints.
>
> My question is, given the integrity in gauranteed is it better to just
> have indexes on the second platform without the foreign/primary key
> constaints.
>
> Will we gain performance not have these constraints.

It depends upon what performance to which you refer.

No constraints could make the ETL processing faster. Having no constraints won't make SELECTs any faster. As you are aware, CONSTRAINTS only impact INSERT, UPDATE & DELETE Received on Fri May 27 2005 - 19:22:37 CDT