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. |