Subject Re: [IB-Architect] Index Sync/Rebuild Question
Author Jason Chapman
From: Jim Starkey <jas@...>
> >Ahhh.. So does that explain why a gbak restore will build
> >selectivity and a empty database freshly populated does not?
> >
> Indeed it does. In the absense of a valid selectivity, the
> optimizer uses .01 . Why not?
> Jim Starkey
Because that's bad.....
At least the docs should state that after you have a representative amount
of data in your database you should instigate recalculation of selectivity.