Database index suggestion processing method and device, medium and electronic equipment
A processing method and database technology, applied in the database field, can solve problems such as difficult to quantify the impact of database performance, limited improvement of database performance, and inability to effectively evaluate performance benefits, so as to improve optimization processing efficiency and save time and content of manual analysis rich effect
Pending Publication Date: 2021-01-01
北京人大金仓信息技术股份有限公司
View PDF0 Cites 3 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, at present, database indexes are generally created manually, which tests the technical ability of database administrators.
Therefore, some databases provide index suggestions, but the scope of suggestions is still limited, resulting in limited improvement of database performance, so further improvement of database performance is needed
In addition, it is currently difficult or even impossible to effectively evaluate how much performance benefit the created index suggestion can bring to the SQL statement to be optimized, making it difficult to quantitatively analyze the impact of the created index suggestion on database performance
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
[0051] 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.
[0052] 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.
[0053] First, some terms involved in the embodiments of the present disclosure are explained.
[0054] Index suggestion: For a given database and Structured Query Language SQL (Structured Query Language) statement, the index suggestion DDL statement for creating an index is given, which usually ...
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 a database index suggestion processing method and device, a medium and electronic equipment, and the method comprises the steps: capturing and recording indexable informationcorresponding to a preset query clause when a to-be-optimized SQL statement is executed to the query optimization stage to optimize the preset query clause; creating an optimization index suggestion for the to-be-optimized SQL statement based on the indexable information; and based on the optimization index suggestion, creating a hypothesis index, and based on the hypothesis index, determining a performance improvement yield rate of the to-be-optimized SQL statement. According to the scheme, different optimized index suggestions can be created based on different preset query clauses, the rangeof the index suggestions is wide, quantitative performance can be calculated and given to improve the yield, the content of the index suggestions is richer, time and resources are saved when the index suggestions are created and the yield is calculated by introducing the hypothesis index, the database performance is improved on the whole, meanwhile, the manual analysis time is saved, and the index suggestion optimization processing efficiency is improved.
Description
technical field [0001] Embodiments of the present disclosure relate to the field of database technology, and in particular, relate to a database index suggestion processing method, a database index suggestion processing device, a computer-readable storage medium and an electronic device for realizing the database index suggestion processing method. Background technique [0002] Before the database executes the structured query language SQL statement, it generally goes through several stages of lexical analysis, syntax analysis, semantic analysis, query rewriting and query optimization, as well as generation of execution plan and execution. In this way, SQL statements can be executed more efficiently, saving database resources and improving database performance. [0003] Creating reasonable indexes is one of the key factors in improving database performance. An index is a structure that sorts the values of one or more columns in a database table, using an index to quickly ...
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 Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/242G06F16/2453
CPCG06F16/2246G06F16/24532G06F16/2433
Inventor 尹强
Owner 北京人大金仓信息技术股份有限公司