Analysis And Tuning
SQL Navigator provides useful tools for tuning and database management. These tools are intended to be used in conjunction with each other.
| Icon | Tool | Description |
|---|---|---|
 |
Analyze Tool | View and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes. |
 |
Explain Plan Tool | Analyze the execution of a single SQL statement. By examining the execution plan, you can see exactly how Oracle executes your SQL statement, and how it can be improved. |
 |
ER Diagram | Model a table and graphically see the dependencies and joins to other tables. |
 |
Code Road Map | Display the complex PL/SQL inter-dependencies within a database. |
 |
Integration with Benchmark Factory | Benchmark Factory® is a highly scalable load testing, capacity planning and performance tuning tool capable of simulating thousands of users accessing your database, file, Internet and messaging servers. |