Subject | Adding indexes on live datasets |
---|---|
Author | rodbracher |
Post date | 2005-12-09T13:01:33Z |
Hi
Do you think it is bad adding an index to a relation on a live
dataset? There is a fairly good chance that relation will be being
queried / posted to at the same time. This is a single field, not part
of the PK index.
I would always avoid metadata updates such as field changes etc. but
here I must way the cost of bringing the system down for an operation
that may be safe live.
Thanks
Rod
Do you think it is bad adding an index to a relation on a live
dataset? There is a fairly good chance that relation will be being
queried / posted to at the same time. This is a single field, not part
of the PK index.
I would always avoid metadata updates such as field changes etc. but
here I must way the cost of bringing the system down for an operation
that may be safe live.
Thanks
Rod