Actually I am talking about the sppr_populate_index_data('identiffier', 'tablename') stored proc that will execute alter table "MYSCHEMA"."SOMETABLE" compress sequential


From: Knut Anders Hatlen <Knut.Hatlen@Sun.COM>
To: Derby Discussion <>
Sent: Thursday, August 20, 2009 2:19:01 PM
Subject: Re: Running stats while online

T K <> writes:

> Does anyone anticipate any issues running statistics while Derby is
> online? Or am I better off bringing it offline?


When you say statistics, are you talking about the runtime statistics
that you can obtain by executing the SYSCS_SET_RUNTIMESTATISTICS system
procedure followed by SYSCS_GET_RUNTIMESTATISTICS? If so, it should only
affect the session in which these procedures are executed, and I'm not
aware of any problems (performance or other) caused by running them on a
live system.

If you were asking about some other kind of statistics, please let us

Knut Anders