Re: How to reuse pages in other tables?

Hi, Answer your question one by one. At 04:44 PM 2/10/98 +0200, Leonids.Voroncovs@dati.lv wrote: >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 ==> Informix default first extent and next extent is 8k, or 4 pages. > ... >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? > ==> Informix count continues extents as one extent. Because you use load command load huge data from file, so the disk use being used are conitnues, that is the reason you see huge extent size. >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? > ==> Once extent are allocated to table, they will occupy by table even you delete rows. Only way to free up space is unload table, delete table and load back data. Hope I answer your question. >Best wishes. Leonid. ( Leonids.Voroncovs@dati.lv ) > > Paul Hsu SKECHERS USA 228 Manhattan Beach Blvd Manhanttan Beach, CA 90266 Phone : (310) 3183100 X 1287 Fax : (310) 3185019 E-mail: paulh@skechers.com