does unique constraints hurt insert performance

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 Received on Sat Aug 12 2006 - 18:52:22 CDT