The Research on the Optimization Method for Database SQL Query
Yang Jie Wu · 2001
By analyzing the optimization of DBMS and the factors that affect the SQL query efficiency, avoided non-compatible data model, supplied redundancy parameter to junction condition, estimated data logging with average density, avoided math command character such as ! = or in clause WHERE, and NOT EXISTS and NOT IN are introduced. The optimization methods of clause WHERE and SQL query sentence are considered at first when the functions are applied.