The Schema and Table Inspector includes the ability to analyze and repair tables, and also view table metrics.
Use the Schema Inspector to browse general information from schema objects. It allows you to perform maintenance tasks on tables such as ANALYZE, OPTIMIZE, CHECK, and CHECKSUM TABLE. To access the inspector, right-click on a schema and select the Schema Inspector
Each tab lists topic oriented information, such as "Tables", "Indexes", and "Triggers". From the Tables tab, click to open the Table Inspector, or to open the table maintenance tools:
View table information, similar to the Schema Inspector. This also has a simpler and easier to use interface for analyzing and creating indexes for your tables.
To open, right-click on a table in the object browser and choosefrom the context menu.
The Table Inspector shows information related to the table.