Thanks for your reply. Even with a much lower fillfactor than the default,
it still contains at least one overflow page. The wonder is, how to get rid
of that one page overflow for a isam table?
> Sent: Tuesday, September 07, 1999 2:57 PM
> To: Lee, Boon-Cheow
> Subject: RE: How to get rid of overflow pages in an ISAM table?
> Take a look at fill factor. You could modify the table using a lower
> fill factor, as far as I can recollect the default fill factor is 80 %,
> you could try with a lower percentage, but then the total number of pages
> will increase. You would need to take a look at the SQL and DBA manuals.
> "Luck is what happens when preparation meets opportunity." --- Coach
> Darell Royal
> -----Original Message-----
> Sent: Tuesday, September 07, 1999 11:52 AM
> To: 'info-ingres'
> Subject: How to get rid of overflow pages in an ISAM table?
> Hi All,
> Wonder is there any way we can get rid of overflow pages in an ISAM
> storage structure table? Even an empty isam table contains 1 overflow
> page. See below. For the rest of isam table, there are at least 1 overflow
> Lee Boon Cheow
> MobileOne, Singapore
> 1> help table
> Name: isamtmp
> Owner: dba_cabsprod
> Created: 06-sep-1999 11:13:00
> Location: gsmdb_loc0
> Type: user table
> Version: ING6.0
> Row width: 215
> Number of rows: 0 <-- no rows
> Storage structure: isam
> Compression: none
> Duplicate Rows: allowed
> Number of pages: 2
> Overflow data pages: 1 <-- but 1 overflow
> pg - ie unavoidable !
> Journaling: disabled
> Base table for view: no
> Permissions: none
> Integrities: none