80002xiaotgagainhehe
　　Executedin0seconds
　　SQL>colidfora10;
　　SQL>colnamefora40;
　　SQL>select*fromxiaotg.testcfwhereid=80002;
　　IDNAME
　　--------------------------------------------------
　　80002xiaotgagainhehe
　　Executedin0.016seconds
　　SQL>select*fromxiaotg.mv_testcf2whereid=80002;
　　IDNAME
　　--------------------------------------------------
　　80002xiaotgagainhehe
　　Executedin0.031seconds

　　 测试基表正常情况下的COMMIT速度　　

SQL>dropmaterializedviewmv_testcf2;
　　Materializedviewdropped
　　Executedin1.984seconds
　　SQL>
　　SQL>
　　SQL>insertintoxiaotg.testcf(id,name)values(80003,'xiaotgagainhehe3');
　　1rowinserted
　　Executedin0seconds
　　SQL>commit;
　　Commitcomplete
　　Executedin0seconds

上一页 1 2 3下一页