I'm trying to work out the consequences of some table structure changes in terms of file sizes. Is there a guide anywhere? I had a look through the help pdf and couldn't spot anything.

If it included suggestions on calculating index sizes that would be a major bonus.

Roy Lambert

Roy,

<< I'm trying to work out the consequences of some table structure changes
in terms of file sizes. Is there a guide anywhere? I had a look through the
help pdf and couldn't spot anything.

If it included suggestions on calculating index sizes that would be a major
bonus. >>

There really isn't any way to calculate index sizes ahead of time without
knowing the actual data, due to the compression used.  For non-primary key
indexes, the size of the index will be smaller (compared to a full index
without compression) as the amount of duplicate index keys in the index
grows.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


In that case hows about the data? I seem to remember a post about you'd reduced the size of storeage needed for an integer.

Roy Lambert

Roy,

<< In that case hows about the data? I seem to remember a post about you'd
reduced the size of storeage needed for an integer. >>

Not integers, but the size of DECIMAL/NUMERIC columns is much smaller (-28
bytes), and the size of BLOB column information in a row is smaller by 4
bytes.

--
Tim Young
Elevate Software
www.elevatesoft.com