You can use these Toad tips and techniques for SQL tuning:
Identity Security Risk Assessment
Get a free AD security assessment to evaluate your environment and identify the most actionable issues.
Video: ‘Dan’s Dozen’ Quick Toad Tips: Tip #4 – DBMS_XPLAN
