EXPLAIN PLAN

SQL> explain plan for

2 SELECT * FROM TBLBANKDETAIL;

Explained.

SQL> set linesize 160

SQL> set pages 300

SQL> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT

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

Plan hash value: 3594628191

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

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |

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

| 0 | SELECT STATEMENT | | 100K| 10M| 253 (1)| 00:00:04 |

| 1 | TABLE ACCESS FULL| TBLBANKDETAIL | 100K| 10M| 253 (1)| 00:00:04 |

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

8 rows selected.

SQL>