I hope our experts had answered your queries, besides if you're facing performance issues while retrieving the data from the tables OR while querying views,you could go for Indexed views. Please make sure the underlying tables are normalized , as you mentioned these are archive tables.