Re: [firebird-support] How much percentage of a database space is a table contents taking.

 

> Hi Robert, you can do this easily with a tool such as IBExpert. Just run
> Services / Database Statistics and this is the result:
>
> TableName Size Usage%
> CUSTOMER 11,960,320 0.295
> PARAMFIL 16,384 1 0.000
> POSTCODES 3,903,012,864 96.335
> POSTCODE_MISSING 16,384 1 3.000
>
> I've removed a lot more detail such as number of records, pages, fill
> size etc.

Or low-level, for free, running gstat. ;-)

--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

__._,_.___

---

Posted by: "Thomas Steinmaurer" <ts@iblogmanager.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___