Primary Key Constraints vs just indexes

From: Iain William Wiseman <bibble_at_paradise.net.nz>
Date: Sat, 28 May 2005 12:12:31 +1200
Message-ID: <4297b76e$1@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. Advantages and disadvantage would be appreciated. Remember it only our customer replication which inserts/updates/deletes so we do not need to worry about breaking referential integrity.

Thanks all,
Iain Received on Fri May 27 2005 - 19:12:31 CDT