Need clarification on PPI

Database

Need clarification on PPI

CREATE SET TABLE EMPLOYEE_TABLE

(

EMPLOYEE INTEGER NOT NULL

,DEPT INTEGER

,FIRST_NAME VARCHAR(20)

,LAST_NAME CHAR(20)

,SALARY DECIMAL(10,2)

)

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

Tags (1)
2 REPLIES
Teradata Employee

Re: Need clarification on PPI

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.

Re: Need clarification on PPI

why upi defined otherthan partioned column has to probe all partions for duplicate key?is there any chance of getting duplicates id's