|Subject||Re: [firebird-support] Doubts regarding statistics of indexes and tables...|
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] <firstname.lastname@example.org> wrote:
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.