Method for creating database indexes by means of dynamic analysis

The invention discloses a method for creating database indexes by means of dynamic analysis. The method includes implementation procedures of capturing database execution statements and parsing query structures; setting query structure counter models and arranging parsed numerical values into counters; setting counting thresholds and checking index conditions of data tables when the counters reach threshold ranges; creating and adjusting data table indexes according to index checking conditions and processing strategies. Compared with the prior art, the method for creating the database indexes by means of dynamic analysis has the advantages that the method is close to practical application, adaptive to business types, high in practicality, wide in application range and easy to popularize, the processing strategies are clear, and the like. 本发明公开了种通过动态分析创建数据库索引的方法，其实现过程为：捕获数据库执行语句，解析查询结构；设置查询结构计数器模型，将解析后数值放入计数器中；设置计数阈值，计数器达到阈值范围，检查数据表的索引情况；根据索引检查情况及处理策略，创建及调整数据表索引。本发明的种通过动态分析创建数据库索引的方法与现有技术相比，具有贴近实际应用、适应业务类型、处理