Next point: I have seen before deactivating and activating the indices, the
RDB$STATISTICS-column is 0,00 for all my indices and after rebuilding the
indices all values are greater then 0,00. I don't know, what this mean,
because I don't know what the column is for.


Guido

Nando Dessena wrote:

> Guido,
>
> > I have a empty DB and I insert several thousands of datasets. Now I open
> > a query and it takes 0,1362 sec. Now I deactivate all my indices
>
> <SNIP>
>
> > Then I acivate all my indices
>
> <SNIP>
>
> > Now I open the query again and it takes nearly 4 sec.
> >
> > Have anybody a idea, what the reason is for this behaviour ?
>
> 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
> --
> ____
> _/\/ando
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/