Re: Waht deos following exxplain plan mean?

From: jimmyb <jimmybrock_at_gmail.com>
Date: Tue, 18 May 2010 14:40:22 -0700 (PDT)
Message-ID: <8b745018-88a4-4807-ae7c-cf9d119611ff_at_v12g2000prb.googlegroups.com>

On May 18, 2:31 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
> 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|
> ------------------------------------------------------------------------------

Where is the result cache information section of the explain plan? This will provide info on how the result cache was used.

It appears it did a FTS of complaint_info and returned 1 row to the result cache. But the explain plan is missing key information. Received on Tue May 18 2010 - 16:40:22 CDT