Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> how to interpret dbms_xplan.display
I am using dbms_xplan.display to generate explain on a 9.2
database(see below). Just wondering what is what is the unit of the
last column "Cost" and "%CPU"? And why is the "Rows" show 12M where
an index is being used? Thanks.
SQL> explain plan for select * from seq where id = 1000000; Explained.
SQL> select * from table(dbms_xplan.display);
| Id | Operation | Name | Rows | Bytes |Cost (%CPU)|
Predicate Information (identified by operation id):
2 - access("SEQ"."ID"=1000000) Received on Mon May 10 2004 - 17:58:57 CDT
![]() |
![]() |