--- In IBObjects@yahoogroups.com, "Marco Menardi" <mmenaz@...> wrote:

>
> --- In IBObjects@yahoogroups.com, Hans <hhoogstraat@> wrote:
> >
> > If u used GBAK to get a ODS11.0 or FB2.0, it recalculates the
> selectivity
> >
>
> Thanks, I used IBDatapump (http://www.clevercomponents.com/) 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
SET STATISTICS INDEX indexname
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.
Thanks!