Subject Doubts regarding statistics of indexes and tables...
Author Javier Cintron
Post date 2018-05-12T00:29:46Z
Firebird ver 2.5.7.27050 64 bits
Superserver
Windows Server 2012R2


In firebird, how do you calculate statistics to feed the query optimizer? 

Note: I know that the command: 'set statistics index <index_name>;' calculate statistics for indexes, but what about tables for example?


And my second question:

is there any way to backup the statistics before recalculate them?

Note: This backup can be very useful if the new statistics create a performance problem

Thanks in advance for your help