We do a lot of inserts into a table that has a primary key on an identity
 column. Also the key is defined as a unique constraint.
 Theory would call for some additional latency as it has to check for
 uniqueness, but since its an identity column, can we safely remove that
 unique constraint and that way, we can speed up the inserts ?You may ignore this thread. I guess the primary key has a unique constraint
to it
"Hassan" <hassan@.test.com> wrote in message
news:ur1FBJpQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> We do a lot of inserts into a table that has a primary key on an identity
> column. Also the key is defined as a unique constraint.
> Theory would call for some additional latency as it has to check for
> uniqueness, but since its an identity column, can we safely remove that
> unique constraint and that way, we can speed up the inserts ?
>
Friday, March 9, 2012
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment