![]() Toad will prompt you to provide some information about this SQL statement. Click on the Auto-Optimize icon on the Editor's toolbar. ![]() Load a problematic SQL statement into the Toad Editor window. If you're a DBA who is constantly bombarded with requests from developers to tune their SQL, this is a great way to have them tune SQL themselves. Auto-Optimizer is available in Toad for Oracle Xpert Edition and higher. Thankfully, the Auto-Optimizer feature in Toad for Oracle makes tuning SQL a snap, and you don't have to leave the familiar Toad UI. Even when you have great tools like Quest SQL Optimizer, people can be reluctant to hop into a different UI with so many powerful options. ![]() SQL Optimization is intimidating for a lot of people.
0 Comments
Leave a Reply. |