8.2.3 Schema and Table Inspector
The Schema Inspector and Table Inspector each include the ability to analyze and repair tables, and also view table metrics.
Schema Inspector
Use the Schema Inspector to browse general information from schema objects (shown in the figure that follows). It allows you to perform maintenance tasks on tables such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. To access the inspector, right-click a schema and select the Schema Inspector.
Figure 8.23 Schema Inspector
Each tab lists topic-oriented information in categories, such as tables, indexes, and triggers. From the Tables tab, click to open the Table Inspector, or to open the table maintenance tools (shown in the figure that follows).
Figure 8.24 Schema Inspector: Table Maintenance
Table Inspector
You can use the Table Inspector to view table information, which is similar to the Schema Inspector. The Table Inspector includes an easy-to-use interface for analyzing and creating indexes for your tables. To open, right-click a table in the object browser of the Navigator pane and choose from the context menu.
The Table Inspector shows information related to the table. The next figure shows an example using the sakila.actor table.
Figure 8.25 Table Inspector: Info Tab
© 2025 Oracle
Licensed under the GPLv2 License.
https://docs.oracle.com/cd/E17952_01/workbench-en/wb-develop-object-management-inspector.html