Database index creation method and device

Abstract

The invention discloses a database index creation method and device. The method comprises the following steps of when a data query operation occurs or a preset statistic period is ended, analyzing statistic data of the data query operation to determine a query combination group, the data query operation frequency of which satisfies a preset automatic index creation condition; and establishing a corresponding data table index according to the query field combination. By adoption of the method and device, the data query performance can be improved.

Description

technical field [0001] The invention relates to database technology, in particular to a database index creation method and device. Background technique [0002] Most of the current applications use databases to store underlying data, and a large number of data query operations are often required during the running of the application. When the amount of database data is large, a large number of data query operations will have the problem of poor query performance. For example, it takes too long to query specific data results, which will take a long time to return the data results to the client. In extreme cases, when the query cannot be executed within a certain period of time, it will cause a database timeout error and the client cannot obtain The data results in an error page. In addition, querying specific data requires a large number of server I / O operations, so it will also bring greater load pressure to the database server. [0003] At the beginning of the creation o...

AI Technical Summary

Problems solved by technology

When the amount of database data is large, a large number of data query operations will have the problem of poor query performance

For example, it takes too long to query specific data results, which will take a long time to return the data results to the client. In extreme cases, when the query cannot be executed within a certain period of time, it will cause a database timeout error and the client cannot obtain The result of the data results in an error page

In addition, querying specific data requires a large number of server I / O operations, so it will also bring greater load pressure to the database server

[0003] At the beginning of the creation of the database table, due to the relatively small amount of data, there will be no query performance problems at this time. However, after the program runs for a period of time, as the amount of database data increases, the above problems will occur when a large amount of data is queried. The problem of poor query performance

[0004] It can be seen that when the application program has a large amount of data in the database table, the above query performance problems will exist at runtime

Images