Re: Deep meaning of error 3232

From: SL <no.spam_at_thank.u>
Date: Fri, 2 Jul 2004 17:13:12 +0200
Message-ID: <cc3u2a$cf2@news.rd.francetelecom.fr>

"SL" <no.spam_at_thank.u> a écrit dans le message news: cc3q2q$ae2_at_news.rd.francetelecom.fr...
[snip]
Before I get flamed, here is the exec plan of a query I managed to identify
as part of the process described in my previous post

  select /*+ INDEX(t1 DETENTEUR_PK) */
  t1.*, t2.StatutTechnique
    from DETENTEUR t1, GLB_DETENTEUR t2

   where t1.REFTYPEELTAROUTER=t2.REFTYPEELTAROUTER
     and t1.IDELTAROUTER=t2.IDELTAROUTER
     and t1.CODEBASICATDETENTEUR=t2.CODEBASICAT
     and t1.REFINSTANCEDETENTEUR=t2.REFINSTANCE

SELECT STATEMENT, GOAL = CHOOSE    864   1    189
 HASH JOIN         864   1    189
  TABLE ACCESS BY INDEX ROWID      849   3466 308474
       OF EFBADMIN.DETENTEUR
   INDEX FULL SCAN                  23   3466
    OF EFBADMIN.DETENTEUR_PK
  TABLE ACCESS FULL                10    8168  816800

   OF EFBTRAVAIL.GLB_DETENTEUR DETENTEUR is a heavy work table, GLB_DETENTEUR is a temporary table (10-12 rows/tx max)

That query is the only one that features join of any type ;)

Sorry for my mistake.

--
SL

Received on Fri Jul 02 2004 - 10:13:12 CDT