Device and method for optimizing execution plan and based on practice testing
A technology for executing plans and optimizing devices, applied in computing, special data processing applications, instruments, etc., can solve problems such as tight use of database resources, performance degradation of business systems, inaccurate statistical information, etc., to reduce the probability of wrong execution plan selection , the effect of increasing computational overhead and reducing the probability of misjudgment
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0029] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below in conjunction with specific embodiments and with reference to the accompanying drawings.
[0030]The technical idea of the present invention is based on cost-based execution plan optimization, introduces statistical information of resource consumption during actual execution of the execution plan, and incorporates actual inspection results into the consideration range of execution plan evaluation. When the execution plan changes, the system will still give priority to the historical execution plan with the smallest actual cost that has been tested in practice, but the system will regularly evaluate the new execution plan generated by traditional cost optimization. When the evaluation value of the new plan is less than the old one Execute the actual consumption cost of the plan, the new plan will be used. This...
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