In Quest SQL Optimizer for Oracle, what is the use of "Best practices"
Use Best Practices in Optimize SQL 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
Notes: Best Practices is only available in SQL Rewrite mode in Optimize SQL. The Best Practices tab is not displayed by default. To display the Best Practices tab, click , select Optimize SQL | Best Practices | General, and select the Display Best Practices tab in SQL Rewrite mode checkbox.
To view best practices:
Select the Optimize SQL tab in the main window.
Select a SQL Rewrite session.
Select a statement in the Alternatives Details pane.
Click best practices icon. (Refer to the Help file then search best practices for the icon image)
Click the bulb icon. (Refer to the Help file then search best practices for the icon image)
This information is obtainable from the Help file. For more information about best practices please refer to the Help file in Quest SQL Optimizer for Oracle.
