Database index optimization method and device, computer equipment and storage medium

The invention relates to a database index optimization method and device, computer equipment and a storage medium. The method includes extracting database operation information from at least one flowfragment obtained from a database, and the database operation information at least comprises database...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: FAN YUAN, LIU BO, SHAO WANYAN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention relates to a database index optimization method and device, computer equipment and a storage medium. The method includes extracting database operation information from at least one flowfragment obtained from a database, and the database operation information at least comprises database operation statements and execution times of the database operation statements; performing data processing on the database operation statement to obtain index information; detecting at least one candidate factor in the database operation statement of each flow fragment, and counting the execution times of the database operation statement carrying the candidate factor, the candidate factor comprising index information carrying a preset character and/or an executed database operation statement; screening out a target factor from the at least one candidate factor according to the execution times of the database operation statement carrying the candidate factor; and according to the target factor, generating an index s