Database query optimization method and device, electronic equipment, medium and program product
A query optimization and database technology, applied in the database field, can solve the problems of long query time and low query efficiency of database query statements, and achieve the effect of reducing query time and improving query efficiency
Pending Publication Date: 2022-03-25
北京人大金仓信息技术股份有限公司
View PDF0 Cites 1 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, using the existing technology, there is a problem that the query time of the database query statement is too long and the query efficiency is low
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0040] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be further described below. It should be noted that, in the case of no conflict, the embodiments of the present disclosure and the features in the embodiments can be combined with each other.
[0041] In the following description, many specific details are set forth in order to fully understand the present disclosure, but the present disclosure can also be implemented in other ways than described here; obviously, the embodiments in the description are only some of the embodiments of the present disclosure, and Not all examples.
[0042] At present, the database system is widely used in computer application technology. With more and more data stored in the database, among the massive data, users need to use the shortest time to obtain data has become an urgent problem in database query.
[0043] In the prior art, the data...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention relates to the technical field of databases, and provides a database query optimization method and device, electronic equipment, a medium and a program product. The method comprises the steps that a first execution plan corresponding to a database query statement is determined based on first statistical information, second statistical information is obtained according to the first execution plan, and the first statistical information is determined according to a data table, a data row and a data column at least included in a database; the first execution plan is a first execution plan tree corresponding to the database query statement; adjusting the first statistical information based on the second statistical information to obtain target statistical information; based on the target statistical information, a target execution plan corresponding to the database query statement is determined, a query result is obtained according to the target execution plan, and the target execution plan is a target execution plan tree corresponding to the database query statement. By adopting the mode, the query time of database query operation can be shortened, and the query efficiency is improved.
Description
technical field [0001] The present disclosure relates to the technical field of databases, in particular to a database query optimization method, device, electronic equipment, media and program products. Background technique [0002] At present, the database system is widely used in computer application technology. With more and more data stored in the database, among the massive data, users need to use the shortest time to obtain data has become an urgent problem in database query. [0003] In the prior art, the database query statement is parsed and processed by the parser to obtain the query tree corresponding to the database query statement, the optimizer calculates the execution cost according to the query tree, and selects the optimal execution cost to determine the execution plan. The executor determines the execution plan by calculating the cardinality corresponding to the query tree, and finally, the executor runs the execution plan to obtain the query results corre...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More IPC IPC(8): G06F16/2453G06F16/2458G06F16/242
CPCG06F16/2453G06F16/2433G06F16/2462
Inventor 范国腾尹强
Owner 北京人大金仓信息技术股份有限公司