I have seen, that before I deactivate and activate my indices the
RDB$INDEX_INACTIVE-column is null for all my indices and after activating them
there is a 0. where is the difference between NULL and 0 in this case ?


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/