I have the following table.
create table T (K1 date, K2 int, K3 varchar(10), C1 int, C2....)
The table will be partitioned by K1 (K1 has low selective. the data will be appended in the order by
K1). Which of the following primary key is preferred?
alter table T add primary key (K1, K2, K3) alter table T add primary key (K2, K3, K1)