Unique index for insertAsBatch()

[colemanw]

Database used - Microsoft SQL Server 2008Please consider this table structure:\[code\]create table SubscriptionDetails (detailid int primary key identity(1,1), userid int, eventid int, taxonomyid int, contenttypeid int, typeid int, objectid int,CONSTRAINT unique_detail UNIQUE (userid,eventid,taxonomyid,contenttypeid,typeid,objectid) with (IGNORE_DUP_KEY = ON));\[/code\]We use Java JDBC and make use of Statement:executeBatch() method to increase performance. Since the unique_detail constraint creates index on all the columns, will there be any performance issues? By having the constraint and IGNORE_DUP_KEY = ON we are now able to use the insertAsBatch command without any failures. To use insertAsBatch() and without duplicates is this the only possible way?