Thank you for your help. It was very helpful!
On Sunday, May 13, 2018, 12:50:26 AM CDT, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
Javier wrote:
>
> Ok, but how do I restore the statistics? Using "update" statements?
You do not
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
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
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
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
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
Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2
In firebird, how do you calculate statistics to feed the query optimizer?
Note: I know that the command: 'set statistics index ;' calculate
statistics for indexes, but what about tables for example?
And my second question:
is