Re: free space in .dat files

In article <3rs0ab$ias@cssun.mathcs.emory.edu> ant01@margherita.record.unipd.it "ant01" writes: > As everybody knows, Informiz doesn't use phisical deletion but logical > deletion. > > So, in a ".dat" file we have a lot of "logically" not used space. > > How can we calculate this lost space, knowing the number of rows > contained in a table and the its structure ? (very) Approximately rowsize+4 * nrows. To recover it, alter an index to CLUSTER which will recover the free space for you. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================