CREATE SET TABLE EMPLOYEE_TABLE
EMPLOYEE INTEGER NOT NULL
PRIMARY INDEX (EMPLOYEE)
PARTITION BY DEPT;
In the above eg we cannot have UPI over Employee column since the table is not partioned by that column.
Can anyone explain the reason for this
The database would be required to look in all partitions in order to enforce the uniqueness which would be very high cost during insert/update as well as a complex process.