Hello Matheus,
>Is there a way of finding out how many pages are used to store a given
table?
Run gstat -r, there will be exact information - Data Pages: NNN
CFG (149)
Primary pointer page: 2736, Index root page: 2737
Average record length: 71.20, total records: 15549
Average version length: 10.54, total versions: 48, max versions: 16
Data pages: 875, data page slots: 875, average fill: 81%
If you prefer convenient GUI interface, our IBAnalyst tool can show this
and other information in more friendly way and even calculate
tables/indices sizes in Mb.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
