At 09:16 AM 1/17/2003 +0000, Michael Fung <ibo@...> wrote:

>A field is varchar(200) charset ASCII, and it must be unique. If I
>create a unqiue index on that field, will it hurt performance
>obviously, especially for insert?

There won't be any more effect from this than from any other
index, but the real answer lies in your application. Either
a unique index or a UNIQUE constraint will be faster and more
reliable than any other method. Have you modelled this?


Regards,

Ann
www.ibphoenix.com
We have answers.