I forgot to tell you that I'm working on release 8.1.7 and if I'm not
mistaken indexes like 'SNAP_$' do no more exist.
Please, correct me if I'm mistaken.
-----Message d'origine-----
De : Mike J Kurth [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 11 septembre 2001 08:25
À : Multiple recipients of list ORACLE-L
Objet : Re: Snapshot performance issue
It may be that the name of your index has changed.
It is probably something like I_snap$_E I_REF_EMETTEUR.
You will need to change the hint to reflect the change.
01 01:40
AM PST
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
cc:
I have a view based on the query below which is executed in a reasonable
way
on the master site but this same view takes hours on the snapshot site.
Any
idea
CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2 AS
select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E
I_REF_EMETTEUR)
*/
E.COMP_EMETTEUR, E.NOM_STATION, E.REF_EMETTEUR, E.PIRE, E.PIRE_CALCULEE,
E.HAUT_SOL_ANT, E.AZIMUT, E.ELEVATION, E.OWNER, E.CODE_INTERNE_TS,
E.CODE_INTERNE_TC, E.DEP_CODE_GESTION, SY.COMP_SYSTEME, SY.NOM_SYSTEME,
O.COMP_OPERATEUR, O.CODE_OPERATEUR, SI.COMP_SITE, SI.REF_SITE,
SI.NOM_SITE,
A.COMP_ANTENNE, A.NOM_ANT, MO.REF_MODU, AM.REF_AMPLI, MR.REF_MAT_RECEPT,
LF.CODE_ETAT, ST.CODE
from t_station E, t_antena A, t_site SI, t_system SY, t_operator O,
t_lf_states LF,
v_station_modu MO, v_station_ampli AM, v_station_recept MR, t_status ST
where E.COMP_SYSTEME = SY.COMP_SYSTEME and E.COMP_OPERATEUR =
O.COMP_OPERATEUR
and E.COMP_SYSTEME = O.COMP_SYSTEME and E.COMP_SITE = SI.COMP_SITE
and E.COMP_ANTENNE = A.COMP_ANTENNE and E.COMP_EMETTEUR =
MO.COMP_EMETTEUR
(+)
and E.COMP_EMETTEUR = AM.COMP_EMETTEUR(+) and E.COMP_EMETTEUR =
MR.COMP_EMETTEUR(+)
and not (E.SUPPR_A_ANALYSER_FAE is not null and E.SUPPR_A_ANALYSER_FAE
= 'O')
and E.TYPE_STATION = LF.COMP_ETATS and E.COMP_STATUS = ST.COMP_STATUS(+)
and exists (select 1 from v_mygroup_users
where E.owner=user_name and rownum<=1);
----------------------------------------------------------------------------
-------------
Abiy Alemu
Phone: (+33) 1-58 17 04 56
Fax: (+33) 1-58 17 04 54
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike J Kurth
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ALEMU Abiy
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
