[Info-Ingres] How can I check used page size for one row

[Paul Mason]

On 25 Apr 2007 00:29:59 -0700, labartez <bartlomiej.oles at gmail.com> wrote:
>
> Hello Guys
>
> I want to separate rows by pages.
> One row per page.
>
> Do You know have can I check page size used by one row?
>
>
help table table_name will tell you

 help table t1\g
Executing . . .

Name:                 t1
Owner:                ingres
Created:              21/08/2006 19:06:28
Location:             ii_database
Type:                 user table
Version:              II9.0
Page size:            2048
Cache priority:       0
Alter table version:  0
Alter table totwidth: 25
Row width:            25               <<<<<<<<<
Number of rows:       4
Storage structure:    heap
Compression:          none
Duplicate Rows:       allowed
Number of pages:      3
Overflow data pages:  0
Journaling:           enabled after the next checkpoint
Base table for view:  no
Permissions:          none
Integrities:          none
Optimizer statistics: none

Column Information:
                                                                  Key
Column Name                      Type       Length Nulls Defaults Seq
i1                               integer         1  yes    null
t1                               varchar        20  yes    null

Secondary indexes:    none


-- 
Paul Mason
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070425/b6ae27e0/attachment.html