Re: Extent/Next Extent
Greg,
More info next time please.
If the table is already allocated and you want to know the current
allocations just do a "dbschema -d dbname -t tabname -ss" this will
give you the current sizes. Warning the extents are in kbytes not
pages.
If you are planning on creating a table. Work out the expected size
add some room for growth (I usually add 20%) and specify this as your
extent size in kbytes. I usually do a next size of 20% of the primary
allocation.
Regards
David Ashby
______________________________ Reply Separator _________________________________
Subject: Extent/Next Extent
Author: Greg Kuntz <gtkuntz@mema.mail.fedex.com> at WCA-INET
Date: 15/12/97 9:09 AM
What's the best way to determine the Extent size and Next Extent size in
Informix ?
Greg Kuntz