https://userapps.support.sap.com/sap/support/knowledge/en/3591415
3591415 - Massive Table Unloads Happen During HANA Consistency Check | SAP Knowledge Base Article
You observe many tables are unloaded from memory during HANA consistency check every day. However, those tables are not loaded explicitly before that....