To clarify my second question:
"2) ALSO, do you think that I will see a performance improvement on INSERTS if the column does not have a UNIQUE contraint (since it has to be checked at every insert) ?"...

...what if the column has a regular index, not a UNIQUE index or a UNIQUE constraint, will I see performance improvement on inserts.

Any input anyone ?

[Edited by khussain on 11-21-2001 at 11:27 AM]