Subject RE: [firebird-support] Performance with indices
Author Leyne, Sean
Alexandre,

> I want to know if these indices on primary keys have their statistics
> up to date or do I have to recompute them between each file to
> maintain good performance ?

As long as you have defined your primary key using a PRIMARY KEY index,
then the engine knows the index is unique and therefore has a fixed
selectivity value of 1.

As such, you never need to recompute a primary key index.


Sean