A Novel Approach for Finding Optimal Query Plan in RDBMSd
Shani S. Das1, Rejimoan.R2
1Shani.S.Das, Department of Computer Science and Engineering, SCTCE, Trivandrum (Kerala), India.
2Rejimoan.R, Department of Computer Science and Engineering, SCTCE, Trivandrum (Kerala), India.
Manuscript received on 15 August 2015 | Revised Manuscript received on 25 August 2015 | Manuscript Published on 30 August 2015 | PP: 142-145 | Volume-4 Issue-6, August 2015 | Retrieval Number: F4189084615/15©BEIESP
Open Access | Editorial and Publishing Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Information must be organized in such a way that it is able to access, update and manage. Database is a collection of such information that is organized in a well structured manner. Since databases allow flexible data storage, huge amount of information can be stored in it. Structured Query Language (SQL) is used to do database operations especially the retrieval of data inside database. The database operations must not be too time consuming. Hence the database operations must be done in an efficient and effective manner. The existing optimizer relies on cost as well as heuristic approach. Our focus is to find an optimal execution plan for a query.
Keywords: SQL Query, Query Optimizer, Optimal Query Plan
Scope of the Article: Optimal Design of Structures