Subject | Re: [firebird-support] Table information |
---|---|
Author | Thomas Steinmaurer |
Post date | 2014-03-11T06:37:16Z |
> Is there a way to get information like last time the table wasNo.
> updated/changed,
the size in bytes of the table,
With gstat. By investigating the number of pages allocated * page size
of the database.
how much records are
> save in the table?Either via a regular COUNT(*) or if you need an estimation and index
statistics are up-to-date, checkout the selectivity of a primary key index.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.