公开(公告)号：US10901976B2

公开(公告)日：2021-01-26

申请号：US15495569

申请日：2017-04-24

Applicant: Huawei Technologies Co., Ltd.

Inventor： Huijun Liu ,  Yang Ren ,  Maozeng Li ,  Feng Han

IPC: G06F17/00 ,  G06F7/00 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2453

Abstract: A method and an apparatus for determining a structured query language (SQL) execution plan are provided to optimize determining of the SQL execution plan and improve execution efficiency of the SQL execution plan. The SQL execution plan corresponds to at least one relation table. During an Nth iteration, the method includes obtaining a first iteration parameter generated after a first plan tree is executed on the at least one relation table during an (N−1)th iteration, where N is a natural number greater than 1, establishing a second plan tree according to the first iteration parameter, and determining the first plan tree or the second plan tree as the SQL execution plan when a difference between the second plan tree and the first plan tree is not greater than a first threshold.

公开(公告)号：US20170242884A1

公开(公告)日：2017-08-24

申请号：US15495569

申请日：2017-04-24

Applicant: Huawei Technologies Co., Ltd.

Inventor： Huijun Liu ,  Yang Ren ,  Maozeng Li ,  Feng Han

IPC: G06F17/30

CPC classification number: G06F16/235 ,  G06F16/2246 ,  G06F16/24542 ,  G06F16/24545

Abstract: A method and an apparatus for determining a structured query language (SQL) execution plan are provided to optimize determining of the SQL execution plan and improve execution efficiency of the SQL execution plan. The SQL execution plan corresponds to at least one relation table. During an Nth iteration, the method includes obtaining a first iteration parameter generated after a first plan tree is executed on the at least one relation table during an (N−1)th iteration, where N is a natural number greater than 1, establishing a second plan tree according to the first iteration parameter, and determining the first plan tree or the second plan tree as the SQL execution plan when a difference between the second plan tree and the first plan tree is not greater than a first threshold.