Does UNIQUE INDEX = Unique constraint + regular index?

Does UNIQUE INDEX = Unique constraint + regular index?

 

  

Hi,

For column A, I need to make it unique and also index it. Does it the same as put an unique index on this column?

I think they will work the same, but wonder if there is anything I oversee by choosing one over the other. Any performance consideration here?

Thanks,
Elaine








MS Sql Server LazyDBA home page