Subject | Re: [ib-support] Index problem |
---|---|
Author | Nando Dessena |
Post date | 2001-08-09T19:00:29Z |
Guido,
Does the optimizer pick up a different plan before and after rebuilding
the indices?
Ciao
--
____
_/\/ando
> > my guess is that the rebuild operation has forced IB to get all thebad guess then.
> > 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.
Does the optimizer pick up a different plan before and after rebuilding
the indices?
Ciao
--
____
_/\/ando