Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Purely for your amusement

RE: Purely for your amusement

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 27 Feb 2003 15:11:49 -0800
Message-ID: <F001.0055C50C.20030227151149@fatcity.com>


Barbara,
This might be an obvious comment, but isn't the where clause missing a few join conditions? eg - these 3 tables don't seem to get mentioned:

ADMARC.CNR CNR,
ADMARC.WOEMANIFEST_VIEW WOEMANIFEST_VIEW,
ADMARC.WO_CHARG_VIEW WO_CHARG_VIEW

Regards,
Bruce Reardon

-----Original Message-----
Sent: Friday, 28 February 2003 9:51 AM

I found it in our "offending sql statements" report we get from the database each morning. Went looking when someone complained about poor performance. (Ya, do you THINK!!!!) Probably not Discoverer. I think it was either Access or Crystal. (When I found it, it had double quotes around everything, which is usually Access.)

On the bright side, our BHR looks great!!! Guess I'll go home and have a beer.

For Jared's entertainment, here's the sql:

SELECT WO.ACCT_KEY, WO.PUB, WO.ISSUE, WO.STATUS,

WO.AD_TYPE, WO.EDITION, WO.SECTION, WO.AD_DESC,
WO.COMMENTS, WO.JOB_NBR, WO.ACT_SIZE, WO.BASE_AMT,
WO.DISC_TOT,
WO.AGY_COMM, WO.SP_AGY_COMM, WO.INVC_AMT, WO.FREQ,
WO.CIRCULATION,
WO.RC_NBR, WO.AVG_RATE, NAD.NAM1, NAD.PROD_4,
PUB.SLS_EFF_ISS_1, PUB.SLS_NBR_1_1, PUB.SLS_EFF_ISS_2,
PUB.SLS_NBR_2_1, PUB.SLS_NBR_3_1, CNR.SLS_NBR_1, WOEMANIFEST_VIEW.WOE_EDITION, WO_CHARG_VIEW.PROD1,
WO_CHARG_VIEW.AMT1, WO_CHARG_VIEW.PROD2,
WO_CHARG_VIEW.AMT2, WO_CHARG_VIEW.PROD3,
WO_CHARG_VIEW.AMT3, WO_CHARG_VIEW.PROD4,
WO_CHARG_VIEW.AMT4, WO_CHARG_VIEW.AMT5,
WO_CHARG_VIEW.AMT6, WO_CHARG_VIEW.AMT7,
WO_CHARG_VIEW.AMT8, WO_CHARG_VIEW.AMT9

FROM ADMARC.WO WO,
ADMARC.NAD NAD,
ADMARC.PUB PUB,
ADMARC.CNR CNR,
ADMARC.WOEMANIFEST_VIEW WOEMANIFEST_VIEW,
ADMARC.WO_CHARG_VIEW WO_CHARG_VIEW

WHERE WO.ACCT_KEY = NAD.ACCT_NBR (+)
 AND WO.ACCT_KEY = PUB.ACCT_KEY
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 27 2003 - 17:11:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US