Subject | Index deactivitation does what? |
---|---|
Author | Louis Kleiman |
Post date | 2003-04-10T15:58:02Z |
Hi All -
When I deactivate an index before inserting lots of records with FB 1.5 Beta
4, I don't get the performance gain that I do when I drop the index. Is
this a WAD? Why does the server still churn when reactivating the index if
(as it currently seems), the index is still being updated when it is
inactive?
Thanks.
Louis Kleiman
[Non-text portions of this message have been removed]
When I deactivate an index before inserting lots of records with FB 1.5 Beta
4, I don't get the performance gain that I do when I drop the index. Is
this a WAD? Why does the server still churn when reactivating the index if
(as it currently seems), the index is still being updated when it is
inactive?
Thanks.
Louis Kleiman
[Non-text portions of this message have been removed]