It's on MOH_ARTICLES_ASSOCIES
My concern is why I do not see mohd_noeud_article in
the plan .
--- "Weerd Kirsten, E.C. de"
<Kirsten.deWeerd_at_Oranjewoud.nl> a écrit : > 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
> > 'MOHD_ARTICLE_PK'
> > (UNIQUE)
> >
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Wed Aug 16 2000 - 04:39:28 CDT
