Data Management

Analysis of Query Optimization Techniques in Databases

Date Added: Jun 2012
Format: PDF

Query optimization in databases has gain a lot of importance in recent years. In this paper, the authors have analyzed different techniques of query optimization in relational databases and compared their performance. The databases are the best way of storing and viewing the data in form of tables. Databases are most useful in representing data in an organized manner. The query optimization in databases has gained equal importance as it is very important to reduce the size, memory usage and time required for any query to be processed. This improves significantly the performance of the database. Databases can be classified according to their organizational approach.