数据库多条件组合查询优化算法研究

Research on an Optimization Algorithm of Multi-Condition Assembling Query on Database

提出了一种查询优化算法,通过本算法,可以有效地减少查询语句的分支和数量以及IF条件语句的嵌套层数,大大提高了程序代码的可读性,通过分析研究该算法并未降低程序的运行效率。

This article comes up with an query optimization algorithm. The branch and number of query sentence as well as layer number of IF sentence nesting can be decreased via this algorithm effectively. Also the readability of programming code can be improved efficiently via this algorithm. The analysis and research on this algorithm indicates that running efficiency of program has not been reduced.