立即与支持人员聊天
与支持团队交流

SQL Navigator for Oracle 7.5 - 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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级