Tunig required for the below SQL.

[nirkar jena]

SELECT T1.ROW_ID, T1.CREATED_BY, T1.LAST_UPD_BY, T1.NAME, T1.PRTNR_FLG, T1.CMPT_FLG, T1.EMP_COUNT, T1.BASE_CURCY_CD, T1.CUST_STAT_CD, T1.DOM_ULT_DUNS_NUM, T1.DUNS_NUM, T1.EAI_ERROR_TEXT, T1.GLBLULT_DUNS_NUM, T1.MAIN_PH_NUM, T1.OU_NUM, T1.PAR_DUNS_NUM, T1.REGION, T1.URL, T1.X_DO_CONTACT_FLAG, T1.X_DOMESTIC_NAME, T1.X_GU_NAME, T1.X_MARKET, T1.X_MARKET_SEGMENT, T1.X_NAME_IN_LOCAL, T1.X_ONECODE_STATUS, T1.X_PARENT_NAME, T1.X_VENDOR_FLAG, T1.X_GU_COUNTRY, T1.X_INTERMEDIARY_FLAG, T1.X_ONECODE_NAME, T1.X_NUM_OF_EMP_EDITABLE, T1.X_DOMESTIC_COUNTRY, T1.X_HQPARENT_COUNTRY, T1.X_AGU_FLG, T1.X_ASSOC_MHGOLD, T1.X_DB_TOTAL_ASSET_USD, T1.X_DC_TOTAL_ASSET_USD, T1.X_MDN_GOC_MESSAGE, T1.X_MDN_GOC_SUBMIT_STATUS, T1.X_CLIENT_TYPE, T1.X_INT_LEV_TYPE, T1.X_INT_REL_MGR_ID_MDN, T1.X_GLOBAL_REL_MGR_ID_MDN, T1.X_DNB_NAME_MDN, T1.X_DNB_TRADE_NAME_MDN, T1.X_DMG_COMMENT_MDN, T1.X_MDN_GOC_DUPLICATE_CODE, T1.X_MDN_GOC_DUPLICATE_NAME, T1.X_MDN_GOC_INACTIVATION_DESC, T1.X_MDN_GOC_REJECT_DESC, T1.X_ACTIVE_DRMGLOBAL_MDN, T1.X_ACTIVE_DRMINTER_MDN, T1.X_ASSOC_ATTGOLD, T1.X_AUTO_MERGE_DATE, T1.X_AUTO_MERGE_FLG, T1.X_AUTO_MERGE_STATUS_MDN, T1.X_MDN_GOC_DUPLICATE_CODE_FLAG, T1.X_MDN_GOC_DUPLICATE_DATE, T1.X_MDN_GOC_SURVIVING_CODE, T1.X_DNB_GU_ANNUAL_REVN, T4.ATTRIB_04, T4.X_REL_CLIENT_DESC, T4.ATTRIB_34, T5.PR_EMP_ID, --T6.DESC_TEXT as Primary_Industry_Category__c, --T6.SIC as Primary_SIC_Code__c, --T6.NAME as Primary_SIC_Description__c, C.X_OFFICE_CODE, C.X_REGION, T1.PR_INDUST_ID FROM siebel.S_ORG_EXT T1, siebel.S_ORG_EXT_X T4, siebel.S_POSTN T5, siebel.s_contact C--, --siebel.S_INDUST T6 -- where T1.X_CLIENT_TYPE is NOT NULL and T1.CUST_STAT_CD in('Active','Inactive','Pending - Workflow Wizard') AND C.EMP_FLG(+)='Y' and T4.ROW_ID(+)=T1.ROW_ID and T5.ROW_ID(+)=T1.PR_POSTN_ID --and T6.ROW_ID(+)=T1.PR_INDUST_ID and C.ROW_ID=T5.PR_EMP_ID

[Mycroft Holmes]

Here you go you can get forked[^]! Seriously do you expect someone to rewrite your query for you! You do not state your database, from the joins I assume oracle but you have given absolutely zero information!

Never underestimate the power of human stupidity RAH

[Lost User]

There's nothing to rewrite. You select columns and join, that's it - it's as dressed down as it can get. If speed is an issue, consider partitioning your table and verifying the indexes.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Niral Soni]

Rearrange your WHERE clause as below -

WHERE C.ROW_ID = T5.PR_EMP_ID
AND T1.ROW_ID = T4.ROW_ID(+)
AND T1.PR_POSTN_ID = T5.ROW_ID(+)
--AND T1.PR_INDUST_ID = T6.ROW_ID(+)
AND C.EMP_FLG(+) = 'Y'
AND T1.CUST_STAT_CD IN ('Active','Inactive','Pending - Workflow Wizard')
AND T1.X_CLIENT_TYPE IS NOT NULL

Thanks & Regards, Niral Soni