Database Administrator Guide > Database Administrator Guide > Maintaining Storage Structures > Table Pages > Display the Number of Pages in a Table
Was this helpful?
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
Last modified date: 08/28/2024