Information processing method, information processing device, storage medium and server

Abstract

The embodiment of the invention discloses an information processing method, an information processing device, a storage medium and a server. The method comprises the following steps: calculating a discrimination evaluation value of each index when current sampling data in a database is queried based on multiple indexes of the database to obtain a current evaluation value set; obtaining differenceinformation between the current evaluation value set and the initial evaluation value set; and when the difference information does not meet a preset condition, obtaining a standard evaluation value set, and determining index statistical information of the database according to the initial evaluation value set, the current evaluation value set and the standard evaluation value set. By introducinga verification mechanism, it is ensured that the final decision result is closer to the real situation when the distinction degree of indexes in the database has large deviation before and after statistics, and the accuracy of index statistical information is improved; and it is ensured that a wrong execution plan cannot be adopted due to change of the evaluation value, and the database statementexecution efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of communication, and in particular to an information processing method, device, storage medium and server. Background technique [0002] In a database, an index is a separate, physical storage structure that sorts the values ​​of one or more columns in a database table. It is a collection of one or several column values ​​in a table and the corresponding list of logical pointers to the data pages that physically identify these values ​​in the table. It is a decentralized storage structure created to speed up the retrieval of data rows in the table. . [0003] In the related art, index statistical information is calculated in a manner of periodic resampling. Randomly samples multiple data pages in the index each time, and estimates statistics for the entire index based on the data in the multiple data pages. However, since the index statistical information is obtained by random sampling, its ran...

AI Technical Summary

Problems solved by technology

However, since the index statistics are obtained by random sampling, its randomness may easily lead to large deviations between the index statistics and the actual situation, which in turn will affect the selection of the index method.

For example, choosing the wrong index will lead to slow statement execution and increased system resource consumption, resulting in business risks

Images