• Thanks for your thoughts. I'm not sure I agree - with proper indices and queries, don't think that getting the current record data from the history table has to be a performance hit. But it's helpful to consider from multiple perspectives.

    In the meantime, I have identified some attributes that would not change along with other updates, so they could reside in the main table to keep the record_id company.