SQL by pass ​

Availability ​

This feature is available since openGauss 1.0.0.

Introduction ​

Query performance is improved by customizing an execution scheme for typical queries in the TP scenario.

Benefits ​

The TP query performance is improved.

Description ​

In a typical OLTP scenario, simple queries account for a large proportion. This type of queries involves only single tables and simple expressions. To accelerate such query, the SQL bypass framework is proposed. After simple mode judgment is performed on such query at the parse layer, the query enters a special execution path and skips the classic execution framework, including operator initialization and execution, expression, and projection. Instead, it directly rewrites a set of simple execution paths and directly invokes storage interfaces, greatly accelerating the execution of simple queries.

Enhancements ​

None

Constraints ​

None

Dependencies ​

None