Search International and National Patent Collections
|1. (WO2018177060) QUERY OPTIMIZATION METHOD AND RELATED DEVICE|
|Applicants:||HUAWEI TECHNOLOGIES CO., LTD.
|Title:||QUERY OPTIMIZATION METHOD AND RELATED DEVICE|
Disclosed in the embodiments of the present application is a query optimization technique. A query optimization method executed by a data access node, comprising: receiving a query request for querying tenant data; searching for a buffered optimal query plan targeted to the query request; if an optimal query plan is found, using the optimal query plan as a target query plan; if no optimal query plan is found, generating a target query plan corresponding to the query request; submitting the target query plan to a database, the target query plan being used by the database to query the tenant data. Compared to the prior art, in the solution provided by the present application, a data access node rather than a database node converts a logical access (query request) into a query plan (physical data access). Moreover, the present invention uses an optimal query plan to perform query and can reduce query costs as much as possible and improve query performance.