Dynamic optimization method for SQL (Structured Query Language) script

The invention relates to a script optimization technology, and discloses an SQL script dynamic optimization method, which simplifies the operation of developers on a database so as to reduce the learning cost of SQL script optimization. The method comprises the following steps: firstly, intercepting and analyzing a grammatical structure of an SQL script by triggering an optimization mechanism, and checking script specifications; then, dynamically optimizing the SQL script on the basis of the analyzed grammar structure and an index condition returned by a retrieval target database; the target database is retrieved again in combination with different script sets, virtual table sets and retrieval condition sets; and finally, sequentially presenting the SQL script, the table structure information, the execution time, the result set, whether the result set is consistent or not and other information according to the execution efficiency. Through the mode of dynamically optimizing the SQL script, the project develop