Hi, currently I have a unique clustered index key on
GpsDatetime (datetime) asc
ImeiNumber (bigint) asc
Id (primary key) asc
Ideally I would like to get rid of id, but I needed it to be unique
99% of my queries are asking for latest Data, should I be ordering by desc for date and id?
A lot of my queries also ask for EventId, I was wondering if I should include this in the clustered key, or does it have too many already?
The table in question has 100 million rows and grows at a rate of 20 records per second