Subject | Re: [firebird-support] How much percentage of a database space is a table contents taking. |
---|---|
Author | Alan J Davies |
Post date | 2015-11-26T07:46:30Z |
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
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@... [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.
>
>
>