Tuning A query Depends on Selecting/ Retrieving Rows From Tables/ Views. Maining Tuning Operations Of Correlated SubQueries Done With The Help Of "IN,EXISTS,NOT IN & NOT EXITS)
On Oct 7, 9:41 am, Gayathri <[email protected]> wrote: > Hi All, > > Is there a way to Tune Correlated Scalar Subquery? > > I have tried using left outer join too, but there seems no difference in > execution. > also added index to columns used in where clause. > > I will post the query and execution plan soon. > > But Could you please share any experience that helped while working on left > outer join? > > Thanks in advance! > G -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
