Re: [firebird-support] (When to) recalculate statistics ?

2020-02-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-02-26 06:22, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Hello Firebird-Group, > > With our device we recalculate statistics ALWAYS when booting up the > system. Now the DB grows bigger this can now take more than 10 minutes > and delays > the time until we can really

RE: [firebird-support] (When to) recalculate statistics ?

2020-02-26 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
HiTo take decision you first must know what statistics are for server e.g. Firebird. Statistics contain info how selective is some index. If it is PK you know that every entry have only one record. For UK you have same but you can have multiple nulls. For other indexes you can have for one

[firebird-support] (When to) recalculate statistics ?

2020-02-25 Thread Matthias Winkler spmm...@gmail.com [firebird-support]
Hello Firebird-Group, With our device we recalculate statistics ALWAYS when booting up the system. Now the DB grows bigger this can now take more than 10 minutes and delays the time until we can really work with the system. As it is not a server and we expect the system to be restart from time to