Display the Number of Pages in a Table
To see how many pages are in a table, you can use the SQL statement HELP TABLE, or use Director or VDBA.
A display for a B-tree table is shown in this example:
Name: emp
Owner: ingres
Created: 22-sep-2010 10:27:00
Location: ii_database
Type: user table
Version: II9.0
Page size: 2048
Cache priority: 0
Alter table version: 0
Alter table totwidth: 70
Row width: 70
Number of rows: 32
Storage structure: B-tree
Compression: none
Duplicate Rows: not allowed
Number of pages: 6
Overflow data pages: 0
Journaling: enabled
Base table for view: yes
Permissions: none
Integrities: none
Optimizer statistics: none
Column Information:
Key
Column Name Type Length Nulls Defaults Seq
name varchar 20 no no 1
title varchar 15 no yes
hourly_rate money no yes
manager varchar 20 yes null
Secondary indexes: none