Subject Re: [ib-support] Index problem
Author Nando Dessena
Guido,

> > my guess is that the rebuild operation has forced IB to get all the
> > index pages in the cache, thus eliminating your data pages which were
> > there at the beginning (when you inserted the data).
> >
> > If this were true, you would experience a much smaller delay when trying
> > to open the query a third time.
> > HTH
>
> No, after rebuilding the indices every time opening the query takes longer.

bad guess then.
Does the optimizer pick up a different plan before and after rebuilding
the indices?
Ciao
--
____
_/\/ando