0、制造测试数据https://blog.csdn.net/lizhangyong1989/article/details/45013509 生产一千万条测试数据总共四个字段,每次插入一百万的数据耗时110秒左右create table TestTable asselect rownum as id,to_char(sysdate + rownum / 24 / 3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime,trunc(dbms_random.value(0, 100)) as random_id,dbms_random.string('x', 20) random_stringfrom dualconnect by level <= 1000000;因为
查看全文