| Subject | Re: [firebird-support] Delete the contents of a given index | 
|---|---|
| Author | Christian Brümmer | 
| Post date | 2006-02-16T15:42:39Z | 
Hi Lorenzo,
Lorenzo Lamas wrote:
alter index name_of_index inactive;
alter index name_of_index active;
Best regards
Christian
            Lorenzo Lamas wrote:
> or at least recompute the index contents.You can do this by deactivating and activating the index:
alter index name_of_index inactive;
alter index name_of_index active;
Best regards
Christian