Oracle order by 排序优化(二)

2014-11-24 17:54:41 · 作者: · 浏览: 5
----------------------------------------------


redicate Information (identified by operation id):


--------------------------------------------------


2 - access(SYS_OP_DESCEND("SID")

filter(SYS_OP_UNDESCEND(SYS_OP_DESCEND("SID"))>90)


ote


----


- SQL plan baseline "SQL_PLAN_78qgapzz4mwhwd7223dec" used for this statement


统计信息


---------------------------------------------------------


0 recursive calls


0 db block gets


4 consistent gets


0 physical reads


0 redo size


818 bytes sent via SQL*Net to client


519 bytes received via SQL*Net from client


2 SQL*Net roundtrips to/from client


0 sorts (memory) --无排序


0 sorts (disk)


10 rows processed