Optimization Strategy of SQL Inquiring Database
Fang Zhen-cong · Computer and Modernization · 2005
During the development of database application system, if one does not pay attention to optimization policy of SQL query, everything seems quite smooth in the initial use of the system. But as the database is filled with more and more information, the responding speed will be slowed down, even to an unbearable extent, which probably leads to the elimination of the system through the contest. Thus, it is key to develop database application system successfully that one formats the query system in a logistic and reasonable way. This article is to probe into the need of query optimization and how to optimize database query. Database theory is used in this article and student information management system is taken as example.