SAP SE
Increasing performance of in-memory databases using re-ordered query execution plans

Abstract:

Implementations of the present disclosure include methods, systems, and computer-readable storage mediums for receiving a query from an application, determining that the query has been received before, and in response, retrieving statistics for the query from a metadata table, providing a query execution plan (QEP) associated with the query, the QEP including a plurality of operators executed to provide a query result, one or more operators of the plurality of operators requiring input from computer-readable memory, fragmenting at least one operator of the plurality of operators into multiple fragment operators to provide a fragmented QEP (fQEP), the multiple operators being executed to each provide a portion of a result of the at least one operator, and storing the fQEP in computer-readable memory.