Oracle - Guide Me

Re: Guide Me

From:

Date:

Time:

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C39EE9.1D9DDF40
Content-Type: text/plain

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, <mailto:KarthickS@systechusa.com> KarthickKumar
To: 'oracle-list@digitalpoint.com' <mailto:'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 =b.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

------_=_NextPart_001_01C39EE9.1D9DDF40
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C39F16.7D261310">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"time"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"date"/>

<style>

</style>

</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>

<div class=3DSection1>

The problem is when cost goes high =
my
session get hangs and I won't getting =
output<o:p></o:p>

<o:p> </o:p>=

Regards<o:p></o:p></p=
>

karthick<o:p></o:p></spa=
n>

<o:p> </o:p>=

-----Original =
Message----- 
From: Fabien Sanglard
[mailto:fabien@pcn.fr] 
Sent: =
<st1:date
Month=3D"10" Day=3D"30" Year=3D"2003">Thursday, October 30, =
2003</st1:date> <st1:time
Hour=3D"18" Minute=3D"41">6:41 PM</st1:time> 
To: Oracle List 
Subject: Re: [Oracle] =
Guide Me

<o:p> </o:p>

<div>

I don't really understand =
what is
you probleme. Join two tables is more expensive that select within a =
set of
values....<o:p></o:p>

</div>

<div>

 <o:p></o:p>

</div>

<div>

What is the matter =
?<o:p></o:p>

</div>

<blockquote style=3D'border:none;border-left:solid black =
1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt=
'>

<div>

----- Original Message =
----- <o:p></o:p>

</div>

<div style=3D'font-color:black'>

From:</spa=
n> <a
href=3D"mailto:KarthickS@systechusa.com" =
title=3D"KarthickS@systechusa.com">Santharam,
KarthickKumar</a> <o:p></o:p>

</div>

<div>

To:=
 <a
href=3D"mailto:'oracle-list@digitalpoint.com'"
title=3D"oracle-list@digitalpoint.com">'oracle-list@digitalpoint.com'</a=
> <o:p></o:p>

</div>

<div>

Sent:</spa=
n> <st1:date
Month=3D"10" Day=3D"30" Year=3D"2003">Thursday, October 30, =
2003</st1:date> <st1:time
Hour=3D"13" Minute=3D"41">1:41 PM</st1:time><o:p></o:p></=
p>

</div>

<div>

Subject:</=
span> [Oracle]
Guide Me<o:p></o:p>

</div>

<div>

<o:p> </o:p>

</div>

Hi =
<o:p></o:p>

<o:p> </o:p></f=
ont>

 I am joining two table (one has =
91 lacks recs
and other has 1 cr 51 lacks recs) with one =
condition<o:p></o:p>

Say a.x =3Db.x . the cost =
for this
query is 301234 .if I change the query like =
<o:p></o:p>

<o:p> </o:p></f=
ont>

a.x in =
(1,2,3,4,5...)<o:p></o:p>

<o:p> </o:p></f=
ont>

and<o:p></o:p></font=
>

b.x in =
(1,2,3,4,5,6,6,7,..)<o:p></o:p>

<o:p> </o:p></f=
ont>

tha cost reduce to =
34<o:p></o:p>

<o:p> </o:p></f=
ont>

but I cann't give in =
condition
because I have 500000 distinct values<o:p></o:p>

<o:p> </o:p></f=
ont>

I need your help =
<o:p></o:p>

<o:p> </o:p></f=
ont>

Thanks in Advance =
<o:p></o:p>

karthick<o:p></o:p><=
/font>

</blockquote>

</div>

</body>

</html>

------_=_NextPart_001_01C39EE9.1D9DDF40--

----------------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.digitalpoint.com/lists/oracle.html
----------------------------------------------------------

Sales:
888/4-DPOINT

Support:
858/452-3696