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

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

currently this requires quite a complicated dance with views,triggers,
logfiles and changing access funtions.

> They actually support three modes:
> 
> ALLOW NO ACCESS
> ALLOW READ ACCESS
> ALLOW WRITE ACCESS
> 
> I'm not sure where that leaves us. The word "online" seems deeply ingrained in
> the database vocabulary for this feature but there's a certain amount of
> SQLishness in the DB2 syntax too.
> 
> DB2 also supports some other nice options like interrupting an index build and
> then resuming it later. If there's demand that seems like something we 
> would be
> able to support too. The same infrastructure might be useful for 
> suspending and
> resuming vacuums on large tables too.
> 
> --
> Gregory Stark
> EnterpriseDB          http://www.enterprisedb.com
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com