|
Home > Archive > Oracle Databases > July 2005 > Assistance needed with query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Assistance needed with query
|
|
|
| Hi,
We have the following query:
SELECT w.WELLS_PK, w.WELL_ID, w.PLATE_FK, w.SAMPLE_FK, w.REACTION_FK,
wam. WELLS_AMPLICON_MAP_P
K, a.AMPLICON_PK FROM CL_WELLS w,
CL_WELLS_AMPLICON_MA
P wam, CL_AMPLICON a WHERE
w.WELLS_PK=wam.WELLS_FK(+) AND wam.AMPLICON_FK=a.AMPLICON_PK(+) AND
w.PLATE_FK=300052 ORDER BY w.WELLS_PK
This thing takes (IMHO) waaaaaay to long.
I know next to nothing about oracle, although Im pretty familiar with
mysql. How can I optimize this query? Does sql+ have some sort of
'explain' function?
Any help is appreciated!
Bryan
| |
| Matthias Hoys 2005-07-15, 1:24 pm |
|
"BCC" <bcc@abcz.com> wrote in message
news:p1TBe.2716$mN1.2482@newssvr13.news.prodigy.com...
> Hi,
>
> We have the following query:
> SELECT w.WELLS_PK, w.WELL_ID, w.PLATE_FK, w.SAMPLE_FK, w.REACTION_FK,
> wam. WELLS_AMPLICON_MAP_P
K, a.AMPLICON_PK FROM CL_WELLS w,
> CL_WELLS_AMPLICON_MA
P wam, CL_AMPLICON a WHERE w.WELLS_PK=wam.WELLS_FK(+)
> AND wam.AMPLICON_FK=a.AMPLICON_PK(+) AND w.PLATE_FK=300052 ORDER BY
> w.WELLS_PK
>
> This thing takes (IMHO) waaaaaay to long.
>
> I know next to nothing about oracle, although Im pretty familiar with
> mysql. How can I optimize this query? Does sql+ have some sort of
> 'explain' function?
>
> Any help is appreciated!
>
> Bryan
Hi,
Is this for Oracle 9i ? This might help :
http://download-west.oracle.com/doc...appdev.htm#5855
Matthias
|
|
|
|
|