Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tracing SQL: where is the select in the select ?

RE: Tracing SQL: where is the select in the select ?

From: Weerd Kirsten, E.C. de <Kirsten.deWeerd_at_Oranjewoud.nl>
Date: Wed, 16 Aug 2000 12:00:15 +0100
Message-Id: <10591.114695@fatcity.com>


I'm afraid I can't really tell ...
Sorry, hope someone else has any ideas ...

Greets,

Kirsten

> -----Original Message-----
> From: paquette stephane [SMTP:stephane_paquette_at_yahoo.com]
> Sent: Wednesday, August 16, 2000 11:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tracing SQL: where is the select in the select ?

>=20

> 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 =E9crit : > What table
> is the index MOH_LIEN_33_FK on ?
> >=20
> > > -----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 ?
> > >=20
> > > Hi,
> > >=20
> > > 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 =3D 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 =3D 1110857
> > > AND ass.type =3D 'TAS_PACK'
> > > AND art.id_article =3D ass.id_article_associe
> > > AND m.id_marque =3D art.id_marque
> > >=20
> > >=20
> > > 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)
> > >=20
>=20
>=20

> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>=20

> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20

> 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
Received on Wed Aug 16 2000 - 06:00:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US