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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment