TOAD® Handbook

Using SQLab Xpert Tuning

Ever wished you could push a button and make all your SQL tuning performance issues go away? Well, you can with TOAD’s SQLab Xpert Tuning add-on. SQLab Xpert is by far the world’s greatest SQL Tuning tool ever made. SQLab Xpert truly provides a world-class SQL tuning workbench with both automatic tuning and database structural advice, elevating any DBA or SQL developer to the status of SQL tuning guru. Moreover, the steps are both straightforward and simple:

1.	In TOAD, you identify SQL code that either runs too slowly or has a suspect explain plan (for example, too many nested loops) as shown in Figure 10.7. Then you merely click the SQLab Xpert Tuning icon on the toolbar to tune the SQL. Figure 10.7. TOAD SQL Editor—inefficient ...