COLLECTION ITERATOR PICKLER FETCH

From: Scott Crabtree <scott_at_psscorp.com>
Date: Thu, 10 May 2001 09:46:38 -0700
Message-ID: <F001.002FF7F4.20010510091105@fatcity.com>

Sometimes I really love the developers at Oracle...... This should be good fodder for Eric P.

Does anyone have experience with infamous pickler Fetch which shows up in this explain plan the select is on index organized nested tables (Nested objects)? It's obvious that someone in internals has a good sense of humor. I guess this is the way Oracle dereferences the embedded collections?   SELECT STATEMENT     SORT GROUP BY       NESTED LOOPS         NESTED LOOPS           NESTED LOOPS

            NESTED LOOPS     
`               BLAH BLAH BLAH....

       COLLECTION ITERATOR PICKLER FETCH

          VIEW  AD_AGG_DATA_MASTER

            UNION-ALL PARTITION

              FILTER

                TABLE ACCESS BY INDEX ROWID AD_200003

                  INDEX RANGE SCAN AD_200003_IDX_1

              FILTER

                TABLE ACCESS BY INDEX ROWID AD_200004

                  INDEX RANGE SCAN AD_200004_IDX_1

              FILTER

                TABLE ACCESS BY INDEX ROWID AD_200005

                  INDEX RANGE SCAN AD_200005_IDX_1

Scott Crabtree
Veritas Certified Survivor
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Scott Crabtree
  INET: scott_at_psscorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 10 2001 - 11:46:38 CDT