Click the Tables tab to access the Table Manager. The Table Manager is one central place to view, create, delete, and manage tables of whichever databases that you select after clicking the Browse button. By default, the Table Manager opens with the Columns subtab enabled.

​

Figure 6.8. Table Manager

Gathering Information about a Table

In the DDL, Storage Information, and Detailed Information subtabs, you can view properties, storage, and other information of the particular table selected in the left-side pane.

​

Figure 6.9. Example of Information in the DDL Subtab

​

Figure 6.10. Example of Storage Information Subtab

​

Figure 6.11. Example of Detailed Information Subtab

Running and Viewing Statistics of a Table

To assess how big a table is and to estimate the execution duration of queries that run on the table, you might find the Statistics subtab to be helpful. The subtab also calculates statistics on each column of the table if you want to gather this information.

If statistics do not appear on this subtab, click the Compute button. The button changes to Recompute after you first calculate statistics. You might click Recompute if you want to change whether or not column information is included or if you change the table in some way after the initial calculation of statistics.

In the following screenshot, include columns must be selected and the Recompute button clicked to display column statistics.

​

Figure 6.12. Example of Statistics Subtab