Tablestatistics & Tablesizes

Florian Schmitz <[email protected]>
Newsgroups gmane.comp.db.maxdb
Organization acardo technologies AG
Message-ID <[email protected]>
Hi List,

i try to estimate the space-comsuption of our tables via tablestatistics.
when summing up the pages-count ('Used  pages', 'Index pages') of all tables and break it down to 
human readable values (e.g. dividing it by 8) i just end with a sum of gigs which is just half the 
used data area.
so here's my question : what '%pages%'-fields summed up lead to the real space-consumption? do 
leaf-pages count to space-consumption to?

if only used and index-pages lead to the real space-consumption : where are the dozens of gigs 
beeing wasted? :-)

Thanks,

Flo

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.