Oracle 收集分区统计信息
--删除表DROP TABLE TEST3;--1.创建按日分区测试表SQL> CREATE TABLE TEST3(ID INT, PARDATE DATE) 2 PARTITION BY RANGE (PARDATE) INTERVAL (NUMTODSINTERVAL (1,'DAY')) 3 ( 4 PARTITION P_20180101 VALUES LESS THAN (TO_DATE('2018-01-02', 'YYYY-MM-DD')) 5 );
原创
2021-03-26 11:42:49 ·
1459 阅读 ·
1 评论