单表收集统计信息:
select /*+ dynamic_sampling(t 4) */ * from t where id > 1234
收缩表空间,不需要重建索引:
alter table cntv.dw_wap_base_t2 enable row movement ;
alter table cntv.dw_wap_base_t2 shrink space;
单表收集统计信息:
select /*+ dynamic_sampling(t 4) */ * from t where id > 1234
收缩表空间,不需要重建索引:
alter table cntv.dw_wap_base_t2 enable row movement ;
alter table cntv.dw_wap_base_t2 shrink space;