How to reuse pages in other tables?

Posted in 1998

Leonids.Voroncovs@dati.lv — Tue, 10 Feb 1998 16:44:43 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, All! Please, help. Created a table: CREATE TABLE ... Checked: oncheck -pT database:table ... Number of extents 1 First extent size 4 Next extent size 4 Number of pages allocated 8 Number of pages used 7 Number of data pages 0 Number of rows 0 ... 1st question: Why number of pages allocated is 8 in 1 extent? Loaded data: LOAD FROM ... Checked: oncheck -pT database:table ... Number of extents 2 First extent size 4 Next extent size 4 Number of pages allocated 9336 Number of pages used 9334 Number of data pages 7955 Number of rows 103411 ... 2nd question: Why number of pages allocated is 9336 in 2 extents? Deleted data: DELETE FROM ... Checked: oncheck -pT database:table ... Number of extents 2 First extent size 4 Next extent size 4 Number of pages allocated 9336 Number of pages used 9334 Number of data pages 0 Number of rows 0 ... 3rd question: Can I use pages allocated for this table ( but not used ) for other tables? Best wishes. Leonid. ( Leonids.Voroncovs@dati.lv )