Tuning the SQL Query in order to Reduce Time Consumption
The optimizer examines parsed and normalized queries, and information about database objects. The input to the optimizer is a parsed SQL query and statistics about the tables, indexes, and columns named in the query. The output from the optimizer is a query plan. The query plan is compiled code that contains the ordered steps to carry out the query, including the access methods (table scan or index scan, type of join to use, join order, and so on) to access each table. Using statistics on tables and indexes, the optimizer predicts the cost of using alternative access methods to resolve a particular query. It finds the best query plan – the plan that is least the costly in terms of I/O [1].For many queries, there are many possible query plans. Adaptive Server selects the least costly plan, and compiles and executes it. The query process very faster and less cost per query. This query optimization gives the High performance of the system and less stress on the database when data transmission occurs and the efficient usage of database engine and lesser memory consumed.
Keywords: Optimization, Indexing, Normalization, Query Processing, Control methods and search
Download Full-Text
ABOUT THE AUTHORS
Karthik P
He is pursuing M.Tech in the stream of Software Technology (2011-2013) at VIT University, Vellore, Tamil Nadu, India and currently doing internship with Alcatel-Lucent, Chennai. He received Bachelor degree in Computer Science and Engineering from Anna University of Technology, Coimbatore, Tamil Nadu, India. He presented research papers in International and National Conferences, his interested areas are Cloud Computing and Databases.
Thippa Reddy G
He is currently working as an Assistant Professor at VIT University. He has an experience of above 6 years in the teaching field. He received his Masters Degree in Computer Science and Engineering from Sasurie College of Engineering, affiliated to Anna University, Coimbatore in the year 2010. He received his Bachelors Degree in Computer Science and Engineering in the year 2003 from SVH College of Engineering, affiliated to Nagarjuna University, Guntur. He presented research papers in several International and National Conferences. His interested areas are Cloud Computing, Databases, and Theory of Computation.
Kaari Vanan E
KAARI VANAN.E , graduated in Computer Science from Vel Tech Multitech (Affiliated to Anna University Chennai)in 2011.Presently pursuing M.Tech (SoftwareTechnology) at VIT UNIVERSITY, Vellore, Tamil Nadu, India. He presented research papers in International and National Conferences, his interested areas are Object Oriented Systems and Databases.
Karthik P
He is pursuing M.Tech in the stream of Software Technology (2011-2013) at VIT University, Vellore, Tamil Nadu, India and currently doing internship with Alcatel-Lucent, Chennai. He received Bachelor degree in Computer Science and Engineering from Anna University of Technology, Coimbatore, Tamil Nadu, India. He presented research papers in International and National Conferences, his interested areas are Cloud Computing and Databases.
Thippa Reddy G
He is currently working as an Assistant Professor at VIT University. He has an experience of above 6 years in the teaching field. He received his Masters Degree in Computer Science and Engineering from Sasurie College of Engineering, affiliated to Anna University, Coimbatore in the year 2010. He received his Bachelors Degree in Computer Science and Engineering in the year 2003 from SVH College of Engineering, affiliated to Nagarjuna University, Guntur. He presented research papers in several International and National Conferences. His interested areas are Cloud Computing, Databases, and Theory of Computation.
Kaari Vanan E
KAARI VANAN.E , graduated in Computer Science from Vel Tech Multitech (Affiliated to Anna University Chennai)in 2011.Presently pursuing M.Tech (SoftwareTechnology) at VIT UNIVERSITY, Vellore, Tamil Nadu, India. He presented research papers in International and National Conferences, his interested areas are Object Oriented Systems and Databases.
