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)*/
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 ORA
: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 [EMAI