SQL optimization method and device, electronic equipment and computer readable storage medium

Abstract

The invention provides a structured query language (SQL) optimization method and device, electronic equipment and a computer readable storage medium, and relates to the field of databases. The SQL optimization method comprises the steps: analyzing a to-be-optimized structured query language (SQL) to obtain sub-SQL executing table scanning in the SQL and resource overhead of the sub-SQL; when the resource overhead for executing the sub-SQL exceeds a preset overhead threshold, detecting whether index information exists in a key column in a data table corresponding to the sub-SQL or not; and whenthe index information does not exist in the key column in the data table corresponding to the sub-SQL, generating the corresponding index information, and updating the sub-SQL based on the index information to obtain the updated sub-SQL. According to the SQL optimization method, professional technicians or database administrators are not needed for manual troubleshooting, and troubleshooting difficulty, workload and time cost are reduced, and system efficiency and user experience are improved by automatically optimizing the sub-SQL.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular, the present application relates to a structured query language SQL optimization method, device, electronic equipment and computer-readable storage medium. Background technique [0002] At present, most traditional enterprise-level application systems often face such a problem. The efficiency of the project is very fast when the project is just launched. The main reason is that the business processing logic of most enterprise-level applications is relatively complex, and it is inevitable to use many complex SQL queries such as table associations and nested subqueries. When the data volume of the data table reaches the level of millions or tens of millions , the requirements for SQL will be particularly high. Once a full table scan is performed on a data table with a particularly large amount of data, the system efficiency will drop sharply and there may even be a ris...

AI Technical Summary

Problems solved by technology

[0005] This application provides a structured query language SQL optimization method, device, electronic equipment, and computer-readable storage medium, which can solve the problem that developers and professional database administrators check one by one based on their personal experience, resulting in a sharp increase in system efficiency. When it comes to the cause of the decline, the troubleshooting process is cumbersome, the troubleshooting efficiency is relatively low, and the user experience is poor.

Images