达梦列存储

create huge tablespace biphug path '/data/dm8/instance/DAMENG/bip01.dbf' ;
select * from SYS."V$DATAFILE"
create huge table iuap_apdoc_coredoc.productdetail_huge STORAGE(WITH DELTA) tablespace biphug as select * from iuap_apdoc_coredoc.productdetail;
drop table iuap_apdoc_coredoc.productdetail_huge;
create huge table iuap_apdoc_coredoc.productdetail_huge STORAGE(WITH DELTA) tablespace biphug COMPRESS LEVEL 1 as select * from iuap_apdoc_coredoc.productdetail;

压缩前2566M

 

压缩后680M