數據量1000萬條;
oracle10g,11g
oracle10g: alter table big_table_compress nologging;
oracle11g: ALTER TABLE BIG_TABLE_COMPRESS NOLOGGING COMPRESS FOR ALL OPERATIONS
默認建表(Hash),
AVG_ROW_LEN 155
Size in MB 1728.00
Number Extents 210
壓縮表:
AVG_ROW_LEN 156
Size in MB 464.00
Number Extents 129
posted on 2009-04-24 10:54
donnie 閱讀(259)
評論(0) 編輯 收藏 所屬分類:
database