Parallel Execution of Query
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 .