Thx,

I just downloaded IBADMIN few minutes back and am trying that.

regards,
S.

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > I needed to know some statistics like how much space is being

used up

> > by indexes and % of table fill-ups, average length of rows etc
>
> Well, if the documentation doesn't list anything like this in the
> system tables, that should give you a hint, no? This info
> cannot be retrieved from the system tables - also, this information
> has nothing to do with metadata!
>
> You can get (parts of) this information by retreiving the statistics
> with the command line tool "gstat" or via the Services API.
> Most 3rd party tools - Database Workbench included - provide
> a convenient interface for this.
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com