Register now or log in to join your professional community.
I believe that best tool available is your knowledge of SQL and some proper structuring of query.
By knowledge of sql, I mean there are various functions like analytical functions and clauses like with clause that can improve your query. I suggest read as much SQL as you can so that you can discover new concepts for optmization in subjected language.
By restructuring query I mean, write your query such as that it performs minimal calculations at a time.
