000015.OracleSQL执行计划

SQL> conn  ide22/ide22

Connected.

SQL> set  autotrace on

SQL> select  *  from ttt where rownum<2;

OWNER       OBJECT_NAME   SUBOBJECT_NAME     OBJECT_ID       DATA_OBJECT_ID

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

/1005             bd30_Lnkd                 Constant                         17868                JAVA CLASS

 

Execution Plan

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

   0     SELECT STATEMENT Optimizer=CHOOSE

   1   0   COUNT (STOPKEY)

   2   1     TABLE ACCESS (FULL) OF 'TTT'

Statistics

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

        185 recursive calls

          0 db block gets

         24 consistent gets

         10 physical reads

          0 redo size

       1163 bytes sent via SQL*Net to client

        503 bytes received via SQL*Net from client

          2 SQL*Net roundtrips to/from client

          2 sorts (memory)

          0 sorts (disk)

          1 rows processed

SQL> set   autotrace off