Subject | RE: [firebird-support] Performance with indices |
---|---|
Author | Leyne, Sean |
Post date | 2006-04-03T22:20:42Z |
Alexandre,
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
> I want to know if these indices on primary keys have their statisticsAs long as you have defined your primary key using a PRIMARY KEY index,
> up to date or do I have to recompute them between each file to
> maintain good performance ?
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