Intermediate result set caching for a database system

A system comprising:

• a receiving unit configured to receive an access plan for a single query for accessing data stored in the system;
• a generating unit configured to generate an intermediate result set during execution of the access plan;
• a determining unit configured to determine a value of an intermediate result set rating of the intermediate result set during execution of the access plan at runtime of the query for determining if the intermediate result set, generated during the execution of the access plan, is to be stored;
• and
• a storage unit configured to store the determined intermediate result set for a longer period of time than the runtime of the query.

A computer program product for storing intermediate result sets in a database system, the computer program product comprising:

• a computer readable storage medium having program code embodied therewith, the program code executable by a processor to:
• receive an access plan for a single query for accessing data stored in the database system;
• generate an intermediate result set during execution of the access plan;
• determine a value of an intermediate result set rating of the intermediate result set during execution of the access plan at runtime of the query for determining if the intermediate result set, generated during the execution of the access plan, is to be stored;
• and
• based on the determination that the value of the intermediate result set rating meets a predefined criterion, store the determined intermediate result set for a longer period of time than the runtime of the query as a stored intermediate result set.