Abstract: Disclosed herein are systems, methods, and devices for providing load unit recommendations. An example method includes monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Subsequently, the method includes generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values. The load unit indicates whether to load the whole database object, or only a portion thereof, into a main memory of the DBMS while accessing the database object.

Abstract: Disclosed herein are system, method, and device embodiments for providing load unit recommendations. An embodiment operates by monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Some embodiments may further operate by generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values, wherein the load unit may indicate whether to load the whole database object into main memory of the DBMS while accessing the database object or only load a portion of the database object into main memory of the DBMS when accessing the database object.