Waht deos following exxplain plan mean?

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Tue, 18 May 2010 14:31:43 -0700 (PDT)
Message-ID: <1b3e4ed5-3d39-4a2c-a48c-743e5b405fcc_at_q13g2000vbm.googlegroups.com>



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|
Received on Tue May 18 2010 - 16:31:43 CDT

Original text of this message