%0 Journal Article %A Kashif Irfan and Fahad Shahbaz Khan and Tehseen Zia and M. A. Anwar %D 2008 %J International Journal of Computer and Information Engineering %B World Academy of Science, Engineering and Technology %I Open Science Index 13, 2008 %T Weight-Based Query Optimization System Using Buffer %U https://publications.waset.org/pdf/6013 %V 13 %X Fast retrieval of data has been a need of user in any database application. This paper introduces a buffer based query optimization technique in which queries are assigned weights according to their number of execution in a query bank. These queries and their optimized executed plans are loaded into the buffer at the start of the database application. For every query the system searches for a match in the buffer and executes the plan without creating new plans. %P 130 - 132