I'm a data analyst (novice) who writes Oracle 18c SQL queries on a regular basis. I'm aware that my SQL queries are sometimes not structured in the most efficient way possible.
I have a variety of options for learning how to write good queries (learn from books, post on SE Code Review, etc.).
With that said, I'd like to add a tool to my toolbelt: an Oracle SQL optimization tool.
- We're a Toad shop, so I use Toad base version for writing queries. As far as I can tell, Toad Base version doesn't include SQL optimization functionality.
What do you recommend as an Oracle SQL optimization tool? I'm willing to spend up to $300 CAD (out-of-pocket).