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.

Alan J Davies
Aldis

On 26/11/2015 05:38, rgilland1966@gmail.com [firebird-support] wrote:
> I have a large database.
>
> I have some tables that I believe are unnecessary and are taking up too
> much space.
>
> I need to prove this to the boss. to be allowed to change the system.
>
>
> How can I generate a report that gives me a list of table names and
> percentage of overall database the table is holding.
>
>
> Kind Regards,
>
>
> Robert.
>
>
>

__._,_.___

---

Posted by: Alan J Davies <alan.davies@aldis-systems.co.uk>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

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

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

.

__,_._,___