PROTECTED] On
Behalf Of gmei
Sent: 10 June 2003 22:59
To: Multiple recipients of list ORACLE-L
Subject: sql query optimization
Hi:
I have been trying for two days to see if I could optimize
this query without much success. One of the programs here
calls this query many many times
craete a another table that just has
the rows I need, I can often significantly improve performance.
From: Niall Litchfield [EMAIL PROTECTED]
Date: 2003/06/12 Thu PM 01:15:08 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sql query optimization
Given the low
Hi:
I have been trying for two days to see if I could optimize this query
without much success. One of the programs here calls this query many many
times and I hope I could make it run faster. It typically take about 1 sec
to get the result. I have tried using exists to replace in and the
result
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: sql query optimization
]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: sql query
optimization
.com
11/06/2003 07:59
Please respond
at.
Regards,
Mark.
gmei
[EMAIL PROTECTED]To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: sql query
by: cc:
[EMAIL PROTECTED]Subject: Re: sql query optimization
.com