Subject Re: How can I rebuild a PK index?
Author phil_hhn
--- In, 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
> 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).