Heuristic Based Query Optimization

In this paper, the authors will enlist the process of SQL query optimization based on heuristic approach. It is often found in the database industry that a lot of time is consumed in executing inefficient SQL queries. The problem here is that although the DBA knows that the queries red are inefficient, the large sections of people who are actually ring these queries are unable to write efficient queries. As a result, the performance of the entire system degrades because of the drastic fall in the system throughput i.e. the number of transactions performed per unit time is reduced.