A Research on Optimization of Database Query Method
Jiang Yue · Computer Knowledge and Technology · 2011
With the wide use of database,its performance is drawing more and more attention from people.However,due to the complex systematic structure of database,its performance is influenced by various aspects,among which query operation is a key factor.To improve the query efficiency of database and achieve the purpose of optimization of its performance,the paper proposes some strategies to optimize database query,including use of proper index,optimization of query statement,proper use of temporary sheet,optimization of windows and realization of query optimization using optimizer etc.