What table is the index MOH_LIEN_33_FK on ?
> -----Original Message-----
> From: paquette stephane [SMTP:stephane_paquette_at_yahoo.com]
> Sent: Wednesday, August 16, 2000 8:44 AM
> To: Weerd Kirsten, E.C. de; 'ORACLE-L_at_fatcity.com'
> Subject: RE: Tracing SQL: where is the select in the select ?
>
> Hi,
>
> As you 'll see, there is no mohd_noeud_article table
> in the access plan.
> SELECT
> decode(ass.quantite_associe,null,1,ass.quantite_associe)
> as quantite_associe,
> art.nom_court as nom_court,
> art.id_article,
> (SELECT max(dna.id_noeud) FROM mohd_noeud_article dna
> WHERE dna.id_article = art.id_article_generique)
> id_noeud,
> art.etat as etat,
> art.majeur as majeur,
> art.quantite_dispo_vente as dispo,
> art.quantite_seuil as seuil,
> upper(m.nom) as nom_marque,
> concat(to_char(art.prix_frf,'99G9990D99MI'),' FRF') as
> prix,
> art.quantite_maximum as quantite_maximum,
> art.quantite_dispo_vente as dispo,
> art.quantite_seuil as seuil,
> art.majeur as majeur,
> art.etat as etat
> FROM moh_articles_associes ass,
> mohv_article art,
> moh_marque m
> WHERE ass.id_article = 1110857
> AND ass.type = 'TAS_PACK'
> AND art.id_article = ass.id_article_associe
> AND m.id_marque = art.id_marque
>
>
> 0 SELECT STATEMENT GOAL: CHOOSE
> 2 NESTED LOOPS
> 3 NESTED LOOPS
> 3 NESTED LOOPS
> 3 NESTED LOOPS
> 3 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF
> 'MOH_ARTICLES_ASSOCIES'
> 3 INDEX GOAL: ANALYZED (RANGE SCAN) OF
> 'MOH_LIEN_33_FK' (NON-UNIQUE)
> 4 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF
> 'MOH_ARTICLE'
> 4 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
> 'MOH_ARTICLE_PK' (UNIQUE)
> 4 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF
> 'MOH_ARTICLE'
> 4 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
> 'MOH_ARTICLE_PK'
> (UNIQUE)
> 4 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF
> 'MOH_MARQUE'
> 4 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
> 'MOH_MARQUE_PK'
> (UNIQUE)
> 2 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF
> 'MOHD_ARTICLE'
> 4 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
Received on Wed Aug 16 2000 - 04:59:46 CDT
