Do all the 10 columns make a natural key?
03.02.2011, 18:44, "gvim" :
> I have a table with 11 columns and want to eliminate duplication on INSERTs.
> What's the best method? The obvious solution would be to create a UNIQUE
> index on everything except the primary key - 'id' - but that's a 10-co
sql
Betreff: [SQL] UNIQUE on everything except primary key
I have a table with 11 columns and want to eliminate duplication on INSERTs.
What's the best method? The obvious solution would be to create a UNIQUE index
on everything except the primary key - 'id' - but that's a
I have a table with 11 columns and want to eliminate duplication on INSERTs.
What's the best method? The obvious solution would be to create a UNIQUE index
on everything except the primary key - 'id' - but that's a 10-column index and
doesn't sound very efficient. Am I missing something more ob
