> 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 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