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 Inspect Table to open the Table Inspector, or Maintenance 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 Table Inspector 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