Re: does unique constraints hurt insert performance

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 13 Aug 2006 00:54:46 GMT
Message-ID: <Xns981DB638AC35Aanacedenthotmailcom@70.169.32.36>

sunh11373_at_gmail.com wrote in news:1155426742.867263.327670 @p79g2000cwp.googlegroups.com:

> Hi,
>
> If I have a table which has 1 billion rows (data in each row is
> relatively small), delcare one column (not the primary key column) as
> unique, will this cause big problem for inserting?

Quantify "big".

> Assume the inserting rate is 500/sec and the possible duplication is
> 0.001%.

How much will it hurt the application if duplicate records are allowed to exists.

You can't get something for nothing. Received on Sat Aug 12 2006 - 19:54:46 CDT