The only change I discovered, is that the RDB$STATISTICS-column has
become a
value greater 0. Could this be the reason ?


Guido

"Svein Erling =?iso-8859-1?Q?Tysvær?=" wrote:

> >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 ?
>
> Should not matter, the change is the same if you issue ALTER INDEX <name>
> INACTIVE and then ACTIVE again. I guess it is just that the field isn't set
> when creating the index.
>
> I'm puzzled by your problem. I tried the same statement as you wrote (well,
> using IB_SQL, not a SP), and didn't notice any degradation when trying a
> SELECT COUNT ... WHERE <IndexField> = ...
>
> Set
>
>
> 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/