Subject | Update RDB$INDICES |
---|---|
Author | David Montgomery |
Post date | 2004-10-13T17:58:20Z |
Hi,
I'm using FB1.5 for Linux.
Is is possible (or desirable) to perform:
'UPDATE RDB$INDICES SET RDB$INDEX_INACTIVE = 0'
to activate all of the indexes that were set to inactive after
performing a "gbak -r -i" for a problemed database? Will FB
automatically rebuild these indexes internally if I perform this update?
Or should I skip using an update statement, and use the proper 'ALTER
INDEX index_name ACTIVE;' statement?
Thanks!
Best Regards,
David Montgomery
I'm using FB1.5 for Linux.
Is is possible (or desirable) to perform:
'UPDATE RDB$INDICES SET RDB$INDEX_INACTIVE = 0'
to activate all of the indexes that were set to inactive after
performing a "gbak -r -i" for a problemed database? Will FB
automatically rebuild these indexes internally if I perform this update?
Or should I skip using an update statement, and use the proper 'ALTER
INDEX index_name ACTIVE;' statement?
Thanks!
Best Regards,
David Montgomery