Sub projects

• Multiquery optimization (circa 2000)
• Parametric query optimization (circa 2003)
• Nested query optimization (circa 2005)
• Query optimization with batched bindings (2008-current)

Software

• PYRO Top Down Query Optimizer, written by Prasan Roy, available at no charge, on request. Send mail to Prof. S. Sudarshan (http://www.cse.iitb.ac.in/~sudarsha).

  This software is written in C++, and implements a version of the Volcano query optimization algorithm. It also includes multi-query optimization features, but functions as a stand alone optimizer also. Beware that it only supports a very limited subset of SQL; you are free to contribute by extending is SQL support.