Beijing Oceanbase Technology Co., Ltd.

Yi Xiao

Yang Li

Yi Pan

Zhiyong Jiang

Yingying Yao

A database query optimization computer-implemented method, medium, and system are disclosed. In one computer-implemented method, a data query request sent by a client device is received and parsed. An execution plan for executing the data query request is determined based on a parsing result. If the execution plan is a nested loop anti-join, whether there is a possibility that a to-be-queried field in a to-be-queried data table indicated by the data query request contains a NULL value is determined. If there is a possibility that the to-be-queried field contains a NULL value, a filter condition is generated and the execution plan is optimized based on the filter condition.

Growing community of inventors

Hangzhou, China

Yi Xiao