>>Are you using identity field in the Archive table? E.g. the clustered index is on ArchiveID field, right?
>
>No. It's an incremented integer pk kept track of by another table. I use Rick Strahl's wwbusiness class which utilizes this method instead of identity.
>
>>What are the most common queries against Archive table?
>Most of the queries for most of the archive tables are by their pk.
In other words, you don't have a sequential PK that identifies this particular table but rather a PK from the original table, right? In this case I don't think it makes sense to make it clustered. Make it a PK, but non-clustered. You can use timestamp field as clustered index.
If it's not broken, fix it until it is.
My Blog