> 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.


Guido