Re: [SQL] Unique index VS unique constraint

2013-10-05 Thread JORGE MALDONADO
So, let´s say that I have the following simple example table: 1. cus_id 2. cus_name 3. Other fields . . . Where "cus_id" is the primary key. And let´s also say that I want "cus_name" to be unique. I have the option to create a unique constraint or a unique index. What would be the best decision a

Re: [SQL] Unique index VS unique constraint

2013-10-05 Thread Sergey Konoplev
On Sat, Oct 5, 2013 at 3:24 PM, JORGE MALDONADO wrote: > So, let´s say that I have the following simple example table: > > 1. cus_id > 2. cus_name > 3. Other fields . . . > > Where "cus_id" is the primary key. And let´s also say that I want "cus_name" > to be unique. I have the option to create a