Adaptive Plan Selection

Availability

This feature is available since openGauss 3.1.0.

Introduction

This feature triggers plan selection based on the base table condition selection rate, and provides cache multi-plan management and adaptive selection for queries that use partial indexes and offsets. In typical scenarios, the query throughput can be improved by several times.

Benefits

Users can maintain multiple cache plans to adapt to different query parameters, improving query execution performance.

Description

Adaptive plan selection applies to scenarios where a general cache plan is used for plan execution. Cache plan exploration is performed by using range linear expansion, and plan selection is performed by using range coverage matching. Adaptive plan selection makes up for the performance problem caused by the traditional single cache plan that cannot change according to the query condition parameter, and avoids frequent calling of query optimization.

Enhancements

None

Constraints

• Database services are running properly.
• Users have logged in to the database.
• Users have created a database and data table, and have imported data.

Dependencies

It depends on the plan cache function in the database.