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

>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
>
>
Rod,

No problem...

Go on and create the index on live data.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br