Hi Mike,

take a look at ALTER INDEX in the Language Reference.

After the massive operation, activating them will update them automagically.

I don't know about IBConsole, but with InterBase Workbench, you can
right-click on the index-list for the table and select 'deactivate all'.

I must admit this doesn't include system generated indices (like for foreign
keys, primary keys and the such)...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."





Greetings All,

Still relatively new to Interbase.

How does one disable all indexes on a table before doing a massive update or
delete operation? I understand that this would greatly speed the operation
up.

How is it done in IBConsole?

How is it done programmatically?

If the indexes are disabled during a massive update and then they are
enabled after the update, do I need to do anything else to sync the index
with the data? What about after a massive delete operation?