Subject | How does one deactivate indicies during a massive update operation? |
---|---|
Author | M Tuttle |
Post date | 2002-01-03T21:54Z |
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?
Thanks All,
Mike
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?
Thanks All,
Mike