Search Again: Re: Guide Me From: Fabien Sanglard Date: Thursday, October 30, 2003 Time: 5:29:42 am Did you try to create index on fields involved with the join operation ? ----- Original Message ----- From: Santharam, KarthickKumar To: 'Oracle List' Sent: Thursday, October 30, 2003 2:24 PM Subject: RE: [Oracle] Guide Me The problem is when cost goes high my session get hangs and I won't getting output Regards karthick -----Original Message----- From: Fabien Sanglard [mailto:fabien@pcn.fr] Sent: Thursday, October 30, 2003 6:41 PM To: Oracle List Subject: Re: [Oracle] Guide Me I don't really understand what is you probleme. Join two tables is more expensive that select within a set of values.... What is the matter ? ----- Original Message ----- From: Santharam, KarthickKumar To: 'oracle-list@digitalpoint.com' Sent: Thursday, October 30, 2003 1:41 PM Subject: [Oracle] Guide Me Hi I am joining two table (one has 91 lacks recs and other has 1 cr 51 lacks recs) with one condition Say a.x =3Db.x . the cost for this query is 301234 .if I change the query like a.x in (1,2,3,4,5...) and b.x in (1,2,3,4,5,6,6,7,..) tha cost reduce to 34 but I cann't give in condition because I have 500000 distinct values I need your help Thanks in Advance karthick

Messages In This Thread: Guide Me by Santharam, KarthickKumar on Oct 30, 2003 at 4:38:40 am Re: Guide Me by Fabien Sanglard on Oct 30, 2003 at 5:14:11 am Re: Guide Me by Santharam, KarthickKumar on Oct 30, 2003 at 5:21:22 am Re: Guide Me by Fabien Sanglard on Oct 30, 2003 at 5:29:42 am Re: Guide Me by Santharam, KarthickKumar on Oct 30, 2003 at 5:41:13 am