The invention relates to the technical field of
artificial intelligence, can be applied to business scenes such as financial science and technology and
medical health, and discloses an intelligent optimization method, device and equipment for query statements and a medium. The method comprises the steps of recording
execution plan information and
resource consumption information of an original
query statement, generating original execution information, preprocessing the original
query statement and the original execution information to generate preprocessing data, extracting feature information from the preprocessing data, generating optimization information through a pre-trained optimization model based on the feature information, and sending the optimization information to a
server. And according to the optimization information, adjusting the content or execution mode of the original
query statement, and generating an optimization query instruction. According to the method, the feature information is extracted by monitoring the actual query behavior and combining the execution performance, and the optimization strategy is generated by utilizing the training model, so that the automatic optimization of the original query statement is realized, the manual intervention cost is reduced, and the intelligent
adaptation capability of the query performance is improved.