Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

SQL Optimizer

SQL Optimizer supplements Oracle tuning skills for developers. The SQL Optimizer makes observations about a selected SQL statement and the underlying database environment, then recommends several options to improve performance. Users can then view the logic behind the advice, implement the recommendation, apply it to the database, and see the results. The SQL Optimizer module automatically produces all necessary SQL to effect the corresponding change.

Note:

  • SQL Optimizer can be used to analyze the execution of SQL scripts containing more than one statement.
  • SQL Optimizer is an external application. It is installed independently of SQL Navigator.
  • Example Scenario: in the Code Editor highlight the text of the SQL statement you want to investigate and click SQL Optimizer.
  • For more details, see the online help supplied with the SQL Optimizer product.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating