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_PK, a.AMPLICON_PK FROM CL_WELLS w,
CL_WELLS_AMPLICON_MAP 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

"BCC" <bcc (AT) abcz (DOT) com> wrote

Hi,
Is this for Oracle 9i ? This might help :
http://download-west.oracle.com/docs...ppdev.htm#5855


Matthias