How to optimize SQL query on MOO_OPTY — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to optimize SQL query on MOO_OPTY

in Reporting & Analytics for Sales 3 comments

Summary:

A BI Report must extract daily a specific set of specific opportunities

Content (please ensure you mask any confidential information):

We want to query on MOO_OPTY using index MOO_OPTY_F4 on SALES_METHOD_ID.

See the query:

SELECT opty.OPTY_ID AS Opportunity_ID
,opty.OPTY_NUMBER AS Opportunity_Number
,opty.EXTN_ATTRIBUTE_TIMESTAMP001 AS Shippment_Date
FROM MOO_OPTY opty
JOIN MOO_SALES_METHOD_B optySM ON optySM.SALES_METHOD_ID = opty.SALES_METHOD_ID
JOIN MOO_SALES_METHOD_TL optySMDesc ON optySMDesc.SALES_METHOD_ID = optySM.SALES_METHOD_ID AND optySMDesc.LANGUAGE = 'US'
WHERE opty.STATUS_CD = 'OPEN' --BI Report Analisys

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!