What type of load does SAP HANA perform during startup?

During the startup of SAP HANA, the system primarily engages in a process known as lazy loading. This approach allows the database to efficiently load only the necessary data into memory on demand, rather than preloading all data at once. This is particularly useful in optimizing both memory usage and startup time, as it prioritizes the loading of frequently accessed data while deferring the loading of less frequently required data until it is actually requested by a query.

By using lazy loading, SAP HANA can achieve faster startup times because it only populates memory with data that is required immediately, reducing the overhead associated with loading the entire dataset. This method contrasts with other loading strategies that might involve loading all data at once or performing real-time loading in response to transactions, thereby underscoring the efficiency of the lazy loading approach at system startup.