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
Select the Optimize SQL tab in the main window.
Tip: 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.
Enter a SQL statement into the Alternative Details pane.
Click . The Select Connection and Schema window displays.
Select a connection and schema to use.
Review the recommendations provided.