Greetings,

After many years of using Firebird, I thought it might be a good time to
analyze the database statistics. :)
Below are a couple of highly used tables.

From reading Helen's book I gather that a high fill percentage is a good
thing meaning the data pages are being filled with records (or data) with
little wasted space.

The book also states the Data Page Slots should be the same number as Data
Pages. Do I have a problem with my report table (RPT_PI_DTL)?

I can't find anywhere (yet it is early) what the number in parentheses is
after the table name - the "(170)" after CUSTOMERS?
I'm also trying to figure out record size but am just getting into the
analysis. I believe the -r option will give me record size which I will try
next.


CUSTOMERS (170)
Primary pointer page: 1203, Index root page: 1204
Data pages: 426, data page slots: 426, average fill: 93%
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2
80 - 99% = 418



RPT_PI_DTL (387)
Primary pointer page: 1640, Index root page: 1641
Data pages: 5701, data page slots: 6013, average fill: 90%
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 2
60 - 79% = 1
80 - 99% = 5689



Thanks in advance!

Kevin