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