Is the index statistics recomputed during backup and restore process?
Thanks
Ales Kahanek

> -----Original Message-----
> From: Pavel Cisar [mailto:pcisar@...]
> Sent: Thursday, April 03, 2003 2:19 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Progress on making queries run faster
>
>

> It's normal :-) You don't need to drop and recreate, just use
> ALTER INDEX
> INACTIVE and then ALTER INDEX ACTIVE for the same effect.
>
> Why the performance is better after that:
>
> 1) Index statistic is recomputed. It's computed only on index
> creation
> (not very usable for empty database when you create the schema :-),
> recreation by ALTER INDEX ACTIVE and by SET STATISTICS command.