Re: Better name/syntax for "online" index creation

Hannu Krosing <hannu@skype.net> writes:

> Ühel kenal päeval, K, 2006-07-26 kell 06:40, kirjutas Gregory S Stark:
> > The DB2 handbook says "Tables can now be reorganized online with almost full
> > acess to the table allowed" but their syntax does not use the word "online".
> 
> Does this reorganizing refer to what we do with CLUSTER ?
> 
> I'd really love to be able to CLUSTER a table with ALLOW WRITE ACCESS.

It's hard for me to tell from this handbook but it sort of seems like what
you're looking for is "IN PLACE" for which the default is ALLOW WRITE ACCESS.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com