Database SQL index dynamic optimization method
A dynamic optimization and database technology, which is applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems that the time of fault processing depends on engineers, the support of database platform is not very friendly, and the scope of fault influence is expanded, etc., to achieve improvement SQL execution efficiency, reducing the probability of failure and the impact of failure, reducing human dependence and the effect of misoperation
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0035] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.
[0036] figure 2 It is a flow chart of dynamic optimization of database SQL index in the present invention.
[0037] See figure 2 , the database SQL index dynamic optimization method provided by the present invention comprises the following steps:
[0038] Step S1: By configuring scheduled tasks, regularly collect SQL resource usage and establish a resource baseline;
[0039] Step S2: Analyzing the execution plan and the indexing condition of the predicate condition for the collected SQL resource usage;
[0040] Step S3: Track the analyzed data, and if the optimization threshold is reached, implement corresponding index optimization.
[0041] image 3 It is a schematic diagram of the database SQL index dynamic optimization system architecture of the present invention.
[0042] Please continue to see image 3 , the present invention is mainly div...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com