Just another WordPress weblog
create table fenbu as select 1 id,’Y’ flag from dba_objects where rownum<100001;
insert into fenbu values(1,’N');
commit;
create index IDX_FENBU_FLAG on fenbu(flag);
analyze table fenbu compute statistics for table for all columns for all indexes;
var a varchar2(32);
exec :a:=’N';
上一篇文章提到压缩表发生update后会导致行迁移，但是在上篇文章里面没有做过多描述
，这次我们来仔细看一下update compressed table会发生什么事情。此外我们再来看看压
缩表结构修改是怎么处理的。
You are currently browsing the Oracle & Starcraft weblog archives for the month 九月, 2006.
Longer entries are truncated. Click the headline of an entry to read it in its entirety.
