A Survey of Various Query Optimization Techniques
Rini John, Nikita Palaskar · International Journal of Computer Applications · 2017
Data storage and retrieving the data on a specific time frame is critical for any application today.So an efficiently designed query lets the user get the results in the desired time and creates the credibility for the corresponding application.Here in this paper various techniques which are currently used or proposed in recent years and to get a better perspective in this field of query optimization are explored.Automatic external SQL-query optimization method is where the principle of building queries regardless of applied database management system and its settings is explored.It would be interesting to explore the work of authors where they have proposed the energy-efficient query processing and optimization based on a database accelerator.