V
Valeriy Bashkatov
Guest
[quote user="Keith Sudbury"] If you posted the entire output from sp_spaceused I would have a better idea of where the space is being used. [/quote] Thank you! EXEC sp_spaceused N'qc_mstr' GO name rows reserved data index_size unused qc_mstr 408863 144464 KB 130568 KB 13856 KB 40 KB [quote user="Keith Sudbury"] Keep in mind that the 57.6M reported by proutil is the total size of the rows and not how many blocks are required to store the data. The odds are pretty decent (99.9%) that more than 57.6M of space is being used to store that table in OpenEdge. sp_spaceused will show the entire footprint for a table... including reserved pages for future use (think Type II Area cluster size). [/quote] I think you're right. The physical size of the area (Type II) with a single table is almost the same: ls -lah atm_28.d1 -rw-r--r-- 1 root root 112M Мар 10 17:33 atm_28.d1
Continue reading...
Continue reading...