1. A method of tuning a database query, comprising: selecting, a database query: parsing the selected database query to determine relationships between portions of the selected database query: selecting an optimization mode from a plurality of available optimization modes: tuning the selected database query by modifying at least one portion of the selected database query based on the determined relationships and the selected optimization mode: and displaying the modified database query.