公开(公告)号：US20200019552A1

公开(公告)日：2020-01-16

申请号：US16579209

申请日：2019-09-23

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Yong DENG ,  Chenghua LIU ,  Yidong YANG ,  Wenqi ZHU

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F11/34

Abstract: A query optimization method performed by a data access node includes: receiving a query request that is used to query tenant data; searching for a cached optimal query plan for the query request; if the optimal query plan is found, using the optimal query plan as a target query plan; or if no optimal query plan is found, generating a target query plan corresponding to the query request; and submitting the target query plan to a database, where the target query plan is used by the database to query the tenant data. Logical access (query request) is converted into a query plan (physical data access) by the data access node rather than a database node. In addition, the optimal query plan is used for query, so as to reduce a query cost as much as possible, and improve query performance.