本文共 1766 字，大约阅读时间需要 5 分钟。
?????????????????????????????????????I/O???Oracle???????????????????????OLTP????
ALTER TABLE ... MOVE????????????????OLTP????????????????????????????????????????????????OLTP????????SQL????????????
Hybrid Columnar Compression?????????????????????????????????????????????????????????????????????
Hybrid Columnar Compression?????????????????????????????????????????????????????????????????????
Hybrid Columnar Compression??????????
??????????????????
CREATE TABLE orders ( item_id NUMBER NOT NULL, date DATE, num_sold NUMBER, shipped_from VARCHAR(20), restock VARCHAR(1)) TABLESPACE compression_ts COMPRESS FOR OLTP;
?????????????
ALTER TABLE orders COMPRESS FOR OLTP;
????????????????????????
CREATE TABLE sales ( prod_id NUMBER NOT NULL, cust_id NUMBER NOT NULL, ...) PARTITION BY RANGE (time_id)( partition sales_2008 VALUES LESS THAN (TO_DATE('2008-01-01')) COMPRESS BASIC, partition sales_2009 VALUES LESS THAN (MAXVALUE) COMPRESS FOR OLTP); Hybrid Columnar Compression?????????????????????????????????????????????
????????????????????????????????????????????????
?????????????????????????????????????????????
?????????Oracle??????????????????????????????????
转载地址：http://hvpfk.baihongyu.com/