INCREASING PERFORMANCE OF IN-MEMORY DATABASES USING RE-ORDERED QUERY EXECUTION PLANS

摘要

Implementations of the present disclosure include methods, systems, and computer-readable storage mediums for receiving a query from an application, providing a query execution plan (QEP) associated with the query, the QEP including a plurality of operators executed in a first order to provide a query result, one or more operators of the plurality of operators requiring input from computer-readable memory, determining an execution time for each operator in the plurality of operators, re-ordering at least one operator of the plurality of operators to provide a re-ordered QEP (rQEP) based on a respective execution time, the rQEP including the plurality of operators executed in a second order to provide the query result, and storing the rQEP in computer-readable memory.