Subject | Re: [IB-Architect] Index Sync/Rebuild Question |
---|---|
Author | Jason Chapman |
Post date | 2000-05-01T10:05:22Z |
From: Jim Starkey <jas@...>
At least the docs should state that after you have a representative amount
of data in your database you should instigate recalculation of selectivity.
JAC.
> >Ahhh.. So does that explain why a gbak restore will buildBecause that's bad.....
> >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
At least the docs should state that after you have a representative amount
of data in your database you should instigate recalculation of selectivity.
JAC.