Subject Re: [IBO] Is it possible to change plan of a query?
Author Marco Menardi
--- In, "Marco Menardi" <mmenaz@...> wrote:
> --- In, Hans <hhoogstraat@> wrote:
> >
> > If u used GBAK to get a ODS11.0 or FB2.0, it recalculates the
> selectivity
> >
> Thanks, I used IBDatapump ( to
> re-insert all the records. Is it ok, does it make selectivity be up to
> date?
> In any case, I use IBDatapump every time I modify database structure,
> and I've had no problems so far about query plans.
> Marco

Ehm... that was the problem! With a
to the relevant indexes did the trick! So you Hans were right.
Wondering why I had no problem pumping data from 1.5 to 1.5 database,
while I have from 1.5 to 2.0. Wondering if I will still have from 2.0
to 2.0, but I will build a stored procedure to recalculate selectivity
or to rebuild the indexes.