nadeeshaan/JGSoC-SQL-Optimisation — pull request #18 by nadeeshaan (2014-07-21 16:12:47+00:00)
Title: Optimized the killer query2 decomposing in to two and removing the unwan...

As you can see the red color query section in the previous query and compare it with the new query it is clear that the sub select operation is being decomposed in the new query. This is in order to improve the efficiency by using the NOT IN lookup. Since the IN lookup and the NOT IN look up is more efficient rather than the other joining and retrieving the tuples the above decomposition has been used. In the above included query the NOT IN clause is not used. Also removed the unwanted group by clause