Sorry for the late reply.

Yes. That's why it's better to avoid clustered index on a column which values would change constantly.

An important thing you need to consider here is the usage of "LastRevised" column. As the name indicates, I assume, it stores the last modified date of the record. In...