Online Documentation for SQL Manager for InterBase/Firebird

Viewing relations


The Relations tab of Database Monitor allows you to view some of the characteristics of tables and views in the database.

 

Note: This tab is available for InterBase databases only.

 

Database Monitor - Viewing relations

 

 

The list displays the relations as a grid with the following columns:

ID, Relation name, Use count, Sweep count, Scan count, Formats, Pointer pages, Data pages, Garbage collect pages, Page reads, Page writes, Page fetches, Page marks, Indexed selects, Sequential selects, Record inserts, Record updates, Record deletes, Record purges, Record expunges, Record backouts.

If more convenient, you can change the order of the columns by dragging their headers horizontally.

 

Click a column caption to sort items by values of this column in the ascending or the descending mode.

 

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.