Database SQL index dynamic optimization method

Abstract

The invention discloses a database SQL index dynamic optimization method. The method comprises the steps that S1, by configuring timed tasks, SQL resource usage is collected at fixed time, and a resource base line is established; S2, for collected SQL resource usage, an execution plan and indexes of predicate conditions are analyzed; and S3, analyzed data is tracked, and if an optimization threshold is reached, optimization of the corresponding indexes is performed. According to the database SQL index dynamic optimization method, comprehensive monitoring and analysis are performed on SQL usage, and analysis is performed according to the predicate conditions to realize optimization, so that SQL execution efficiency is greatly improved; an SQL performance problem is systematically intervenedand optimized at the initial stage, so that the fault occurrence probability and the fault influence are lowered; and all SQL predicate index analysis is automatically completed without the need forhuman intervention, so that human dependency and misoperation are lowered.

Description

technical field [0001] The invention relates to a database SQL processing method, in particular to a database SQL index dynamic optimization method. Background technique [0002] Information technology has become a crucial productivity in the telecommunications industry, and the quality of business systems directly affects the production of enterprises. At present, the database layer is the most critical link in the traditional enterprise architecture, and the efficient SQL execution efficiency in the database will greatly improve the throughput of the system. [0003] In the current environment, considering that unreasonable index design will generate additional index maintenance consumption caused by DML statements, only the index design of key fields is arranged before the business goes online. During the operation of the system, a large number of variant SQLs are often generated due to changes in business requirements. How to dynamically complete index optimization duri...

AI Technical Summary

Problems solved by technology

[0012] 1), a wide variety, poor security

[0013] At present, various IndexAnalyze systems on the Internet are similar, but there are still many problems in the rigor, timeliness, and accuracy of the monitoring indicators of various manufacturers, and the support for various database platforms is not very friendly.

[0014] 2), only play a monitoring role

We are very cautious about changing the database. Once human error occurs, the scope of failure will be further expanded.

[0018] The above technologies all have the same problem due to their implementation mechanism. When a problem occurs, manual intervention is required to analyze and operate. This series of operations requires a lot of time and requires experienced engineers to complete the process manually. To a certain extent, the time for troubleshooting depends greatly on the engineer's personal ability and familiarity with the environment

Images