thanks for your input.

I tried not to go this route but there are no other choices but track all the changes thsi way, unfortunately.

1. The PK will be Clustered.

2. I'm planing to use vertical partitioning based on the number of rows.

3. Yes, I'm looking for other better solution for this since it's alreay to late to change it now.

I guess, there are not many indexing option since this is already a bad design 🙁

So, any suggestion will be appreciated based on current structure.

thanks again.