A method and apparatus for creating a database index

Abstract

The embodiment of the invention provides a method and a device for creating a database index. The method comprises the following steps: when a query instruction of any structured query language SQL statement is received, the query condition information and the field information in the SQL statement being determined; determining a query condition field in the field information according to the query condition information, and determining a query matching mode of the query condition field; determining a first index name of a database index of the SQL statement to be created according to the query condition field and the query matching mode; creating a database index of the SQL statement based on the first index name. The invention can quickly and accurately carry out corresponding adjustmentoperation on each first index name, and greatly improves the query efficiency of the database and the concurrent processing ability of the data, and avoids the data accident caused by the adjustmentof index name and structure, which leads to the invalidation of the existing query.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for creating a database index. Background technique [0002] The index in the database is like the directory index in the dictionary, which can help users find the corresponding data information faster. With the rapid development of computer technology, existing applications often have a huge number of users, so there is a huge amount of data in the database, and it is necessary to build efficient indexes to increase the speed of query and modification. However, the database index naming convention has always been a difficult problem for software developers and database administrators to unify. In the prior art, taking the relational database management system MySQL database as an example, the index naming method is usually in the form of "index prefix_column name". On the one hand, when there are two index names with similar content, the database administr...

AI Technical Summary

Problems solved by technology

However, the database index naming convention has always been a difficult problem for software developers and database administrators to unify

In the prior art, taking the relational database management system MySQL database as an example, the index naming method is usually in the form of "index prefix_column name". On the one hand, when there are two index names with similar content, the database administrator cannot determine whether One of the indexes can be deleted, so index redundancy is often caused, resulting in wasted disk space and reducing the concurrent processing capability of the database under high load; on the other hand, when performing index-related operations, such as creating a new index, adding For operations such as adding new columns to existing indexes and deleting indexes, the database administrator needs to confirm repeatedly before performing related operations, but it is still unavoidable that the name and structure of the index cannot be adjusted because all SQL associated with the index cannot be traced back, resulting in database performance and Disk capacity has a negative impact, and at the same time, it is unavoidable to adjust the index name and structure, resulting in the invalidation of existing queries, resulting in data accidents

Images