Toad World Blog

Best Practices

Jan 10, 2013 11:00:00 PM by Steve Hilker

You can use Best Practices to analyze your SQL statement and database to recommend common techniques for improving database performance. Since the recommendations can also affect performance of other statements in your database, you should review and test the recommendations before implementing them. When evaluating the recommendations, take into account that database performance is affected by the following:

  • System resources (CPU, I/O, memory, database architecture, and more)
  • Data distribution
  • System architecture
  • SQL execution plans
  • User's usage behavior

Note: The Best Practices function is only available in SQL Rewrite mode in Optimize SQL.

To view best practices

  1. Select the Optimize SQL tab in the main window.

  2. Click TB_BestPractices.

    Tip: To display the best practices tab, click 8836.TB_Options, select Optimize SQL | Best Practices | General, and select the Display Best Practices tab in SQL Rewrite mode checkbox.

  3. Enter a SQL statement into the Alternative Details pane.

  4. Click TB_BestPracticesIcon. The Select Connection and Schema window displays.

  5. Select a connection and schema to use.

  6. Review the recommendations provided.

Tags: Toad for Oracle SQL Optimizer for Oracle Wiki Tutorial

Steve Hilker

Written by Steve Hilker

Steve Hilker was a Product Manager for Quest Software. Steve has over 35 years technical experience spanning application development, system administration, database management and various management positions at several software companies. Steve was the founder of RevealNet, best known for its desktop knowledge bases and unique database tools such as PL/Formatter. RevealNet was acquired by Quest Software in 2001. He's had the pleasure of being the product manager for many of Quest's database tools.

In his private life, Steve enjoys oil painting and living on a small farm in a pre-Civil war manor home in Fredericksburg, Virginia.