| Subject | Re: [firebird-support] Doubts regarding statistics of indexes and tables... |
|---|---|
| Author | Javier Cintron |
| Post date | 2018-05-12T16:03:39Z |
Ok, but how do I restore the statistics? Using "update" statements?
Thanks in advance for your help.
On Saturday, May 12, 2018, 1:19:10 AM CDT, liviuslivius liviuslivius@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
Hi,
to "backup" statistics you can run query on rdb$indices and rdb$index_segment tables. And save result to the file.
About table statistics - here is really fine concept that you do not need to recalculate anything. Table pages count and record size is taken in calc. In fb3 also record compression level.
Regards,
Karol Bieniaszewski