| Subject | Re: [firebird-support] REBUILDING the INDEXES in Firebird |
|---|---|
| Author | Ivan Cruz |
| Post date | 2006-01-27T16:58:26Z |
kapilpatil84firebird wrote:
ALTER INDEX <indexName> ACTIVE;
Note: since ALTER INDEX is a DDL command it cannot be used
inside a stored procedure.
Ivan.
>How to do reindexing in FirebirdALTER INDEX <indexName> INACTIVE;
>Is there any build in SP to do OR we have to fire any SQL command
>
>
>
ALTER INDEX <indexName> ACTIVE;
Note: since ALTER INDEX is a DDL command it cannot be used
inside a stored procedure.
Ivan.