Utilize reoccupying query plan to optimize database performance
Jing Gao · Journal of Changchun Post and Telecommunication Institute · 2003
To optimize database performance based on analyzing the principles of DBMS(Data Base Management System) querying, two RQP(Reoccupying Query Plan) methods are studied: storeprocedure and reoccupying SQL(Structured Query Language)sentence.Based on the presented example, the usages are given. According to developing experiences and constrast analysis, a feasible scheme is presented to optimize database performance: storeprocedure is adopted to add the system remaintence and expansibility and reduce the system's burden. And reoccupying SQL sentence is adopted to reduce the system's complexity and occupancy of system's buffer. A perfect result is obtained in the actual application.