Oracle使用with要小心了--谓词不能推进(二)

2015-07-24 10:36:43 来源: 作者: 浏览: 5
--------------------------------------------------
3 - access("OBJECT_ID"<10)
6 - access("OBJECT_ID">=10 AND "OBJECT_ID"<20)
统计信息
----------------------------------------------------------
1 recursive calls
0 db block gets
4 consistent gets
0 physical reads
0 redo size
381 bytes sent via SQL*Net to client
337 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
-->

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: