I tried to partition a table that has one unique index in the table.
I got error 1503 when I did my partitioning;
A unique index must include all columns in the table’s partitioning function. I partitioned using date column. I believe I must have composite unique index on the column I’m using for partitioning . I have included this but still getting error.
Hello @Dba1,
The partitioning column must be part of every unique index. Since PRIMARY KEY is unique, the column must be part of the PK too.