--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> phil_hhn wrote:
>
> >
> >2) How can I (programatically) recompute the index (without gbak)? > >
> Phil,
>
> the ALTER INDEX statement could not be used on Fk/PK or other "system
> (maintained) indices, you should drop/create the constraint.
>
> BUT, you don't need this. you could just use
>
> SET STATISTICS INDEX YOUR_INDEX_NAME
>
> after commit all statiscts are up-to-date.
>
> see you !
>

Thanks Alexandre, I'll try that sometime soon!

BTW Helen, you asked some time back what I meant by 'programatically'
- I meant running a java app, connecting to the database via JDBC and
running some SQL (via JDBC).

Cheers