Recalculate statistics

[Tomasz Dubiel]

Hey.

Does Jaybird provide a method to recalculate statistics of database indexes?

Best regards,

Tomasz.

[Mark Rotteveel]

On 17/01/2024 14:52, Tomasz Dubiel wrote:
> Does Jaybird provide a method to recalculate statistics of database indexes?

No, you need to execute `SET STATISTICS INDEX <index-name>`[1] yourself.

Mark

[1]:
https://www.firebirdsql.org/file/documentation/html/en/refdocs/fblangref50/firebird-50-language-reference.html#fblangref50-ddl-idx-setsttstcs
--
Mark Rotteveel

[Tomasz Dubiel]

OK, thanks. Yeah, I know about this. IBExpert has such an option and I was wondering whether Jaybird also has it.

Best regards.