Prev: ORA-30036 during ALTER TABLE SHRINK
Next: Waht deos following exxplain plan mean?
From: zigzagdna on 18 May 2010 17:31
See plan below, Does plan mean a FULL TABLE SCAN was done first,
result was then obtained from RESULT_CACHE or a “FULL TABLE CAN” was
done on RESULT_CACHE,
I have run following statement several times and each time it gives me
same plan, so when does it directly get data from RESULT CACHE without
FULL TABLE SCAN. Explain plan is quite confusing.
SELECT COMPLAINT_NO FROM COMPLAINT_INFO WHERE SUSP_COMPLAINT_NO =
2000664

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++
++++ Bind vars ++++
| Operation | Name | Cardinality |
Bytes | Time |
------------------------------------------------------------------------------
| SELECT STATEMENT | |
| ||
| RESULT CACHE |6yhyd84j36s2k0ua8p1 |
| ||
| TABLE ACCESS FULL |COMPLAINT_INFO | 1 |
11 |340|
------------------------------------------------------------------------------
 | 
Pages: 1
Prev: ORA-30036 during ALTER TABLE SHRINK
Next: Waht deos following exxplain plan mean?