Re: Extents

If you were to use 24 for FEXT SIZE or 24000 when loading data it will all be placed into one logical extent. Informix will automatically increase the size of the first logical extent (provided that the additional space is contiguous with the first allocation - this is the case when loading the entire table). However, it's my understanding that the query optimizer prefers that FEXT SIZE be set to what it should be. Therefore, I have created tables with FEXT SIZE of 450000 which was sufficient to hold all the data and have room for growth without adding additional extents. Just beware of the chunk size limit of 2 Gig for Informix. If your table is too big to fit in a chunk < 2 Gig, you'll have to set FEXT SIZE to a smaller value. Also, setting FEXT SIZE too big can also have repercussions. Read the Informix Sys Admin guide to calculate the extent size. It's worth the trouble. Sent via Deja.com http://www.deja.com/ Before you buy.