SQL Language (MOSC)

MOSC Banner

Parallel Execution of Query

edited Dec 26, 2012 3:25PM in SQL Language (MOSC) 3 commentsAnswered

Hello All

Can anyone help me on this below query

SELECT    
DEFICIENCY_COLLECT_DIS 
      from  DOC_REQUEST doc
 WHERE        EXISTS 
                            (SELECT    null
                            from        template t,
                                        LETTER_TYPE LT
                            WHERE     T.CMS_DOC_TYPE_ID = LT.CMS_DOC_TYPE_ID
                            AND       T.CMS_DOC_TYPE_ID = DOC.CMS_DOC_TYPE_ID
                            and       t.template_nm     =  doc.TEMPLATE_ID
                            )
 AND CMS_PRINT_STATUS IN (1,6)
 AND CMS_DOC_TYPE_ID IN (1,5,10,11)
 AND CMS_USER_REQ_ID = '999999999'
 /

Took 26 sec to execute the query

Count of Doc_request  --> 1142206

Count of template --> 10

count of Letter_type --> 42

Column CMS_PRINT_STATUS  ranges from 1-6, cms_doc_type_id ranges from 1-11 only .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center