Improve SQL Query Efficiency with Database Optimizer
Zuo Feng-chao · Journal of Liaocheng Teachers University · 2001
The database optimizer provides an optimal executive strategy for database query. Theexecutive strategy is a series of steps execting query,the reaction speed of database operating is oftenreflected in the optimization algorithm. Different query strategies make much differencd in terms of theresponse rate of server. In this paper,first the property of database optimizer is analysed,then four queryoptimization strategies are given.