I have a table with about 20 fields - I want 6 of them not to allow exact duplicates
I am thinking to make it a unique index but I'm wondering if that's the right way to go about this?
what is the best way to do this?
well, you don't require to use index, you can just create a unique constraint on those fields, that should be better if all you require is not to allow have duplicates.