Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Javier wrote: > > Ok, but how do I restore the statistics? Using "update" statements? You do not "restore the statistics". The statistic that gets updated by a SET STATISTICS call is the selectivity of the index. Low value = high selectivity = Good; high value = low selectivity = bad. The

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Ok, thank you very much! On Saturday, May 12, 2018, 11:42:52 AM CDT, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote:   Hi, i do not suppose that this is possible and especially that you should do this. Better then look at

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Hi, i do not suppose that this is possible and especially that you should do this. Better then look at queries and addapt it to real situation. Regards,Karol Bieniaszewski null

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 liviusliv...@poczta.onet.pl [firebird-support] wrote:   Hi, to "backup" statistics you

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

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