SQL query method and apparatus, and electronic device and storage medium

Abstract

An SQL query method and apparatus, and an electronic device and a storage medium. The method comprises: in response to an acquired SQL statement, determining whether at least one type of execution plan cache data corresponding to the SQL statement is stored in an execution plan cache region, wherein the execution plan cache data stored in the execution plan cache region is evicted on the basis of a cache eviction policy, and the at least one type of execution plan cache data comprises an execution plan or an execution plan outline; if the at least one type of execution plan cache data is not stored in the execution plan cache region, generating an execution plan and an execution plan outline for the SQL statement, and at least storing in the execution plan cache region the execution plan outline as execution plan cache data corresponding to the SQL statement; and if the at least one type of execution plan cache data is stored in the execution plan cache region, on the basis of the at least one type of execution plan cache data, determining an execution plan corresponding to the SQL statement.

Images