Subject | Re: [firebird-support] Adding indexes on live datasets |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-12-09T16:54:49Z |
rodbracher wrote:
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
>HiRod,
>
>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
>
>
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