Subject Re: [firebird-support] Adding indexes on live datasets
Author Alexandre Benson Smith
rodbracher wrote:

>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.

No problem...

Go on and create the index on live data.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil