Re: Quick SE-type question..anyone?

Joseph Kormann wrote: >> >> Hi. As far as I know / can tell, SE doesn't replace or remove rows when >> they're deleted. Is there a way to tell the ratio of deleted to valid rows? >> >> Thanks, >> Joseph > bcheck the .dat file. The output will indicate the number of data rows used and the rows free. Note that files used to store SE tables expand in multiple of the pagesize (usually 2K), which means that some of the free rows indicated by bcheck are not previously occupied rows but rows which have been unused so far. However, for a large table with a lot of deletions, the ratio of 'rows free' to 'data rows' should be a fairly good estimate of 'deleted rows'. HTH ---------------------- Rudy Fernandes GIC, Kuwait ----------------------