I have the following table.
create table T (K1 date, K2 int, ....) on partitionScheme(K1)
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 (the column order is different) is preferred?
alter table T add primary key clustered (K1, K2) alter table T add primary key clustered (K2, K1)
Or should the PK be non-clustered and create another clustered index?