Re: does unique constraints hurt insert performance

On Sat, 12 Aug 2006 16:52:22 -0700, sunh11373 wrote:

> 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?
> Assume the inserting rate is 500/sec and the possible duplication is
> 0.001%.
>
> Thanks

I have an outrageous suggestion: create a copy of the production database, measure time needed for the insertion of 100,000 rows without the index, then re-create the database copy, create the index, re-insert 100,000 rows and measure the new time.

-- 
http://www.mgogala.com