Not something to worry about mcuh. Just put everything in the clustered key and all is well.
create table tbl_statistics
(p_key int identity(1,1),
client_id int not null,
client_datetime datetime not null,
constraint CI_rowId_ClientId primary key clustered (p_key,client_id,client_datetime)
)
If you'd like to have datetime as nullable, than removing client_datetime from the index and it will not cause any changes . The table has just three short columns.
Igor Micev,My blog: www.igormicev.com