Sql Statment Problem

[samir khalil]

السلام عليكم
عندي جملة SQL تم ارفاقها مع الموضوع
هذه الجملة كبيره جدا وفيها joins كتير جداودا بخليها تاخد وقت طويل جدا حوالي 20 دقيقه - والمطلوب مني ابحث عن ايه المشكله بالضبط اللي بتخلي الجمله تاخد الوقت دا كله
بمعني اخر عاوز اخلي الجمله تاخد حوالي وقت ثانيه
مش عارف هيه مشكلة عدد ال joins الكتير ولا الاصدار بتاع DATABASE علما بان الاصدار اللي عندي في الشغل oracle DB 10.0.2
وشكرا

الجمله كالاتي
SELECT /*+ ALL_ROWS */
T67.CONFLICT_ID,
T67.LAST_UPD,
T67.CREATED,
T67.LAST_UPD_BY,
T67.CREATED_BY,
T67.MODIFICATION_NUM,
T67.ROW_ID,
T67.PR_PROVINCE,
T67.PR_ZIPCODE,
T67.COMMENTS,
T67.CSN,
T67.CONSUMER_FLG,
T67.REGION_CD,
T67.CREDIT_AGENCY,
T67.CREDIT_SCORE,
T67.DR_LICENSE_EXP_DT,
T67.DUP_FLG,
T67.DECEASED_FLG,
T67.DEPT_TYPE_CD,
T67.EMAIL_ADDR,
T67.EMP_NUM,
T67.OU_ID,
T67.FAX_PH_NUM,
T67.FST_NAME,
T67.HOME_PH_NUM,
T67.EXT_SYST_ID,
T25.IP_ADDRESS,
T25.SYSTEM_NUM,
T25.MSGXCHG_PRTCL_CD,
T25.NAME,
T25.URL,
T67.AGENT_FLG,
T67.SEMINAR_INVIT_FLG,
T67.JOB_TITLE,
T67.DEDUP_DATACLNSD_DT,
T67.LANGUAGUES,
T67.LAST_NAME,
T67.MAIDEN_NAME,
T67.OU_MAIL_STOP,
T67.CON_MANAGER_PER_ID,
T67.PERSON_UID,
T67.MEMBER_NUM,
T67.MEMBER_FLG,
T67.MOTHER_MAIDEN_NAME,
T67.MID_NAME,
T67.OK_TO_SAMPLE_FLG,
T67.NUM_DEPENDS,
T67.NO_YRS_SCHOOL,
T67.OWNER_LOGIN,
T67.ALT_PH_NUM,
T67.PTSHP_CONTACT_FLG,
T67.PTSHP_KEY_CON_FLG,
T67.UCM_PARTY_UID,
T67.PR_ADDR_LINE_2,
T67.PR_ADDR_LINE_3,
T67.PRIV_FLG,
T67.BIRTH_PLACE,
T67.PREV_JOBS,
T67.PR_GRP_OU_ID,
T67.PR_INDUST_ID,
T67.BU_ID,
T67.PR_PER_ADDR_ID,
T67.PR_CITY,
T67.PR_ZIPCODE,
T67.PR_ADDR,
T67.PR_PROVINCE,
T67.RACE,
T67.PROVIDER_FLG,
T67.PRONUNCIATION,
T67.RETIRED_FLG,
T67.REWARD_PRG_NUM,
T67.SELF_EMPL_FLG,
T67.SEND_NEWS_FLG,
T67.SEND_FIN_FLG,
T67.CUST_SINCE_DT,
T67.SEND_PROMOTES_FLG,
T67.SOC_SECURITY_NUM,
T67.SUPPRESS_SMS_FLG,
T67.INFO_SOURCE_CD,
T67.SUPPRESS_CALL_FLG,
T67.SUPPRESS_FAX_FLG,
T67.SEND_SURVEY_FLG,
T67.ENTERPRISE_FLAG,
T67.SUSPECT_FLG,
T67.CON_ID,
T67.UCM_UID,
T67.UCM_EXT_ID,
T67.WORK_PH_NUM,
T67.YEARS_EMPLYMT,
T67.RESDNCE_YRS,
T67.UCM_TXN_DESC,
T67.PR_ADDR,
T67.PR_CITY,
T67.PR_PROVINCE,
T3.NAME,
T67.CON_ASST_NAME,
T67.ASST_EMAIL_ADDR,
T67.ASST_PH_NUM,
T67.BIRTH_DT,
T67.AFFILIATIONS,
T67.ALIAS_NAME,
T67.PR_DEPT_OU_ID,
T67.ACTIVE_FLG,
T67.PR_MSA,
T67.MAIN_PROFILE,
T67.MAIN_PRFL_EXP_DT,
T67.CON_SOURCE,
T67.PROSPECT_FLG,
T67.INCOME_RANGE_CD,
T67.CALL_FLG,
T67.CELL_PH_NUM,
T67.CUST_END_DT,
T67.IDEN_NUM,
T67.ALT_EMAIL_ADDR,
T67.EMP_FLG,
T67.IDEN2_EXP_DT,
T67.IDEN2_NUM,
T67.IDEN2_STATE_CD,
T67.SUPPRESS_EMAIL_FLG,
T67.SUPPRESS_MAIL_FLG,
T67.NICK_NAME,
T67.X_ANNUAL_SALARY,
T67.X_BENEFITS_PROGRAM_1,
T67.X_BENEFITS_PROGRAM_2,
T67.X_BENEFITS_PROGRAM_3,
T67.X_BENEFITS_PROGRAM_4,
T67.X_BENEFITS_PROGRAM_5,
T67.X_OPENING_BRANCH_ID,
T67.X_CANCELLED_PACKAGE,
T67.X_COMBINED_STATEMENT,
T67.X_IDEN_CUST_NAME,
T67.X_BIRTH_DT_HIJRA,
T67.X_DATE_OF_DEATH,
T67.X_DATE_OF_DEATH_HIJRA,
T67.X_DATE_OF_PROFILING,
T67.X_DATE_OF_RESIDENCE,
T67.X_DATE_OF_RESIDENCE_HIJRA,
T67.X_FAX_PHONE_EXT,
T67.X_FAX_PREF_PHONE_INDICATOR,
T67.X_FIRST_NAME_ARABIC,
T67.X_FROZEN_DATE,
T67.X_HOME_PHONE_EXT,
T67.X_HOME_PREF_PHONE_INDICATOR,
T67.X_IDEN_EXP_DT,
T67.X_IDEN_EXP_DT_HIJRA,
T67.X_IDEN_ISSUE_DT,
T67.X_IDEN_ISSUE_DT_HIJRA,
T67.X_IDEN_STATE_CD,
T67.X_ANNUAL_INCOME,
T67.X_ISLAMIC_PREFERENCE,
T67.X_LAST_CUSTOMER_CONTACT_DATE,
T67.X_LAST_KYC_UPDATE,
T67.X_LAST_NAME_ARABIC,
T67.X_CUST_BUSINESS_LOST_REASON,
T67.X_MAIDEN_NAME_ARABIC,
T67.X_MID_NAME_ARABIC,
T67.X_MOBILE_PREF_PHONE_INDICATOR,
T67.X_NC_EXCLUDE,
T67.X_NUMBER_OF_WIVES,
T67.X_NUMBER_OF_CHILDREN,
T67.X_OPTIONAL_PRODUCT_1,
T67.X_OPTIONAL_PRODUCT_2,
T67.X_OPTIONAL_PRODUCT_3,
T67.X_OPTIONAL_PRODUCT_4,
T67.X_OPTIONAL_PRODUCT_5,
T67.X_OPTIONAL_PRODUCT_6,
T67.X_OPTIONAL_PRODUCT_7,
T67.X_OPTIONAL_PRODUCT_8,
T67.X_IDEN2_EXP_DT_HIJRA,
T67.X_IDEN2_ISSUE_DT,
T67.X_IDEN2_ISSUE_DT_HIJRA,
T67.X_SEC_ID_ISSUE_PLACE,
T67.X_IDEN2_CUST_NAME,
T67.X_OTHER_INCOME,
T67.X_OTHER_INCOME_SOURCE,
T67.X_PARTY_NAME,
T67.X_PRIMARY_CURRENCY_CODE,
T67.X_RESDNCE_VAL,
T67.X_RESPONSIBLE_RM_CODE,
T67.X_CUST_STATUS_CHANGE_DATE,
T67.X_WILLING_PAY,
T67.X_WORK_PHONE_EXT,
T67.X_WORK_PREF_PHONE_INDICATOR,
T67.CALL_FREQUENCY,
T15.NAME,
T15.VAL,
T15.LANG_ID,
T15.TYPE,
T15.BU_ID,
T67.CONTACT_PREF_CD,
T39.NAME,
T39.VAL,
T39.LANG_ID,
T39.TYPE,
T39.BU_ID,
T67.DR_LICENSE_STATE,
T6.NAME,
T6.VAL,
T6.LANG_ID,
T6.TYPE,
T6.BU_ID,
T67.DFLT_ROLE_CD,
T52.NAME,
T52.VAL,
T52.LANG_ID,
T52.TYPE,
T52.BU_ID,
T67.DEGREE,
T23.NAME,
T23.VAL,
T23.LANG_ID,
T23.TYPE,
T23.BU_ID,
T67.ELIGIBLE_DSCNT_CD,
T48.NAME,
T48.VAL,
T48.LANG_ID,
T48.TYPE,
T48.BU_ID,
T67.EMAIL_LOC_CD,
T46.NAME,
T46.VAL,
T46.LANG_ID,
T46.TYPE,
T46.BU_ID,
T67.ALT_EMAIL_LOC_CD,
T21.NAME,
T21.VAL,
T21.LANG_ID,
T21.TYPE,
T21.BU_ID,
T67.INVST_HORIZ_CD,
T17.NAME,
T17.VAL,
T17.LANG_ID,
T17.TYPE,
T17.BU_ID,
T67.INVST_EXPR_CD,
T11.NAME,
T11.VAL,
T11.LANG_ID,
T11.TYPE,
T11.BU_ID,
T67.INVST_PROFILE_CD,
T29.NAME,
T29.VAL,
T29.LANG_ID,
T29.TYPE,
T29.BU_ID,
T67.MARITAL_STAT_CD,
T16.NAME,
T16.VAL,
T16.LANG_ID,
T16.TYPE,
T16.BU_ID,
T67.PREF_COMM_MEDIA_CD,
T28.NAME,
T28.VAL,
T28.LANG_ID,
T28.TYPE,
T28.BU_ID,
T67.RMNDR_COMM_METH_CD,
T59.NAME,
T59.VAL,
T59.LANG_ID,
T59.TYPE,
T59.BU_ID,
T67.PREF_LANG_ID,
T60.NAME,
T60.VAL,
T60.LANG_ID,
T60.TYPE,
T60.BU_ID,
T67.FLWUP_COMM_METH_CD,
T54.NAME,
T54.VAL,
T54.LANG_ID,
T54.TYPE,
T54.BU_ID,
T67.PR_COUNTRY,
T66.NAME,
T66.VAL,
T66.LANG_ID,
T66.TYPE,
T66.BU_ID,
T67.PRIVACY_CD,
T42.NAME,
T42.VAL,
T42.LANG_ID,
T42.TYPE,
T42.BU_ID,
T67.STAT_REASON_CD,
T27.NAME,
T27.VAL,
T27.LANG_ID,
T27.TYPE,
T27.BU_ID,
T67.RELIABILITY_CD,
T12.NAME,
T12.VAL,
T12.LANG_ID,
T12.TYPE,
T12.BU_ID,
T67.REWARD_LVL_CD,
T41.NAME,
T41.VAL,
T41.LANG_ID,
T41.TYPE,
T41.BU_ID,
T67.CUST_STAT_CD,
T63.NAME,
T63.VAL,
T63.LANG_ID,
T63.TYPE,
T63.BU_ID,
T67.PER_TITLE_SUFFIX,
T61.NAME,
T61.VAL,
T61.LANG_ID,
T61.TYPE,
T61.BU_ID,
T67.UCM_TYPE_CD,
T30.NAME,
T30.VAL,
T30.LANG_ID,
T30.TYPE,
T30.BU_ID,
T67.TMZONE_CD,
T9.NAME,
T9.VAL,
T9.LANG_ID,
T9.TYPE,
T9.BU_ID,
T67.CON_CD,
T36.NAME,
T36.VAL,
T36.LANG_ID,
T36.TYPE,
T36.BU_ID,
T67.PR_COUNTRY,
T56.NAME,
T56.VAL,
T56.LANG_ID,
T56.TYPE,
T56.BU_ID,
T67.NATIONALITY,
T10.NAME,
T10.VAL,
T10.LANG_ID,
T10.TYPE,
T10.BU_ID,
T67.COM_PREFERENCE,
T5.NAME,
T5.VAL,
T5.LANG_ID,
T5.TYPE,
T5.BU_ID,
T67.CITIZENSHIP_CD,
T7.NAME,
T7.VAL,
T7.LANG_ID,
T7.TYPE,
T7.BU_ID,
T67.INVST_KNWLDG_CD,
T37.NAME,
T37.VAL,
T37.LANG_ID,
T37.TYPE,
T37.BU_ID,
T67.INVST_RISK_CD,
T65.NAME,
T65.VAL,
T65.LANG_ID,
T65.TYPE,
T65.BU_ID,
T67.SEX_MF,
T32.NAME,
T32.VAL,
T32.LANG_ID,
T32.TYPE,
T32.BU_ID,
T67.PER_TITLE,
T18.NAME,
T18.VAL,
T18.LANG_ID,
T18.TYPE,
T18.BU_ID,
T67.IDEN2_TYPE_CD,
T62.NAME,
T62.VAL,
T62.LANG_ID,
T62.TYPE,
T62.BU_ID,
T67.PREF_COMM_METH_CD,
T31.NAME,
T31.VAL,
T31.LANG_ID,
T31.TYPE,
T31.BU_ID,
T67.X_CORRESPONDENCE_LANG_CODE,
T14.NAME,
T14.VAL,
T14.LANG_ID,
T14.TYPE,
T14.BU_ID,
T67.X_CURRENT_PACKAGE,
T1.NAME,
T1.VAL,
T1.LANG_ID,
T1.TYPE,
T1.BU_ID,
T67.X_EDU_CD,
T55.NAME,
T55.VAL,
T55.LANG_ID,
T55.TYPE,
T55.BU_ID,
T67.X_EMPLMNT_STAT_CD,
T44.NAME,
T44.VAL,
T44.LANG_ID,
T44.TYPE,
T44.BU_ID,
T67.X_FAX_PHONE_PREF_TIME_TO_CALL,
T33.NAME,
T33.VAL,
T33.LANG_ID,
T33.TYPE,
T33.BU_ID,
T67.X_FINANCIAL_INSTITUTION_TYPE,
T43.NAME,
T43.VAL,
T43.LANG_ID,
T43.TYPE,
T43.BU_ID,
T67.X_FROZEN_FLG,
T38.NAME,
T38.VAL,
T38.LANG_ID,
T38.TYPE,
T38.BU_ID,
T67.X_HOME_PHONE_PREF_TIME_TO_CALL,
T64.NAME,
T64.VAL,
T64.LANG_ID,
T64.TYPE,
T64.BU_ID,
T67.X_IDEN_TYPE_CD,
T34.NAME,
T34.VAL,
T34.LANG_ID,
T34.TYPE,
T34.BU_ID,
T67.X_IDEN_COUNTRY_CD,
T50.NAME,
T50.VAL,
T50.LANG_ID,
T50.TYPE,
T50.BU_ID,
T67.X_MARKET_SECTOR,
T45.NAME,
T45.VAL,
T45.LANG_ID,
T45.TYPE,
T45.BU_ID,
T67.X_MIGRATED_FROM_PACKAGE,
T51.NAME,
T51.VAL,
T51.LANG_ID,
T51.TYPE,
T51.BU_ID,
T67.X_MOBILE_PREF_TIME_TO_CALL,
T24.NAME,
T24.VAL,
T24.LANG_ID,
T24.TYPE,
T24.BU_ID,
T67.X_MON_INCOME_CD,
T8.NAME,
T8.VAL,
T8.LANG_ID,
T8.TYPE,
T8.BU_ID,
T67.X_IDEN2_COUNTRY_CD,
T2.NAME,
T2.VAL,
T2.LANG_ID,
T2.TYPE,
T2.BU_ID,
T67.X_RESIDENCE_TYPE,
T19.NAME,
T19.VAL,
T19.LANG_ID,
T19.TYPE,
T19.BU_ID,
T67.X_PARTY_TYPE_CODE,
T20.NAME,
T20.VAL,
T20.LANG_ID,
T20.TYPE,
T20.BU_ID,
T67.X_PREFERRED_BILL_DELIVERY_TYPE,
T13.NAME,
T13.VAL,
T13.LANG_ID,
T13.TYPE,
T13.BU_ID,
T67.X_POSTN_CD,
T22.NAME,
T22.VAL,
T22.LANG_ID,
T22.TYPE,
T22.BU_ID,
T67.X_RECOMMENDED_PACKAGE,
T57.NAME,
T57.VAL,
T57.LANG_ID,
T57.TYPE,
T57.BU_ID,
T67.X_REQUESTED_PACKAGE,
T47.NAME,
T47.VAL,
T47.LANG_ID,
T47.TYPE,
T47.BU_ID,
T67.X_SAMA_CLASS,
T35.NAME,
T35.VAL,
T35.LANG_ID,
T35.TYPE,
T35.BU_ID,
T67.X_SENSITIVITY_DEGREE,
T53.NAME,
T53.VAL,
T53.LANG_ID,
T53.TYPE,
T53.BU_ID,
T67.X_SPEND_PREFERENCE,
T58.NAME,
T58.VAL,
T58.LANG_ID,
T58.TYPE,
T58.BU_ID,
T67.X_CUST_STATUS_CHANGE_METHOD,
T49.NAME,
T49.VAL,
T49.LANG_ID,
T49.TYPE,
T49.BU_ID,
T67.X_VIP,
T40.NAME,
T40.VAL,
T40.LANG_ID,
T40.TYPE,
T40.BU_ID,
T67.X_WORK_PHONE_PREF_TIME_TO_CALL,
T26.NAME,
T26.VAL,
T26.LANG_ID,
T26.TYPE,
T26.BU_ID,
T67.X_ECONOMIC_SECTOR,
T4.NAME,
T4.VAL,
T4.LANG_ID,
T4.TYPE,
T4.BU_ID,
T25.ROW_ID,
T25.MODIFICATION_NUM,
T3.ROW_ID,
T3.MODIFICATION_NUM,
T15.ROW_ID,
T15.TYPE,
T15.LANG_ID,
T15.MODIFICATION_NUM,
T39.ROW_ID,
T39.TYPE,
T39.LANG_ID,
T39.MODIFICATION_NUM,
T6.ROW_ID,
T6.TYPE,
T6.LANG_ID,
T6.MODIFICATION_NUM,
T52.ROW_ID,
T52.TYPE,
T52.LANG_ID,
T52.MODIFICATION_NUM,
T23.ROW_ID,
T23.TYPE,
T23.LANG_ID,
T23.MODIFICATION_NUM,
T48.ROW_ID,
T48.TYPE,
T48.LANG_ID,
T48.MODIFICATION_NUM,
T46.ROW_ID,
T46.TYPE,
T46.LANG_ID,
T46.MODIFICATION_NUM,
T21.ROW_ID,
T21.TYPE,
T21.LANG_ID,
T21.MODIFICATION_NUM,
T17.ROW_ID,
T17.TYPE,
T17.LANG_ID,
T17.MODIFICATION_NUM,
T11.ROW_ID,
T11.TYPE,
T11.LANG_ID,
T11.MODIFICATION_NUM,
T29.ROW_ID,
T29.TYPE,
T29.LANG_ID,
T29.MODIFICATION_NUM,
T16.ROW_ID,
T16.TYPE,
T16.LANG_ID,
T16.MODIFICATION_NUM,
T28.ROW_ID,
T28.TYPE,
T28.LANG_ID,
T28.MODIFICATION_NUM,
T59.ROW_ID,
T59.TYPE,
T59.LANG_ID,
T59.MODIFICATION_NUM,
T60.ROW_ID,
T60.TYPE,
T60.LANG_ID,
T60.MODIFICATION_NUM,
T54.ROW_ID,
T54.TYPE,
T54.LANG_ID,
T54.MODIFICATION_NUM,
T66.ROW_ID,
T66.TYPE,
T66.LANG_ID,
T66.MODIFICATION_NUM,
T42.ROW_ID,
T42.TYPE,
T42.LANG_ID,
T42.MODIFICATION_NUM,
T27.ROW_ID,
T27.TYPE,
T27.LANG_ID,
T27.MODIFICATION_NUM,
T12.ROW_ID,
T12.TYPE,
T12.LANG_ID,
T12.MODIFICATION_NUM,
T41.ROW_ID,
T41.TYPE,
T41.LANG_ID,
T41.MODIFICATION_NUM,
T63.ROW_ID,
T63.TYPE,
T63.LANG_ID,
T63.MODIFICATION_NUM,
T61.ROW_ID,
T61.TYPE,
T61.LANG_ID,
T61.MODIFICATION_NUM,
T30.ROW_ID,
T30.TYPE,
T30.LANG_ID,
T30.MODIFICATION_NUM,
T9.ROW_ID,
T9.TYPE,
T9.LANG_ID,
T9.MODIFICATION_NUM,
T36.ROW_ID,
T36.TYPE,
T36.LANG_ID,
T36.MODIFICATION_NUM,
T56.ROW_ID,
T56.TYPE,
T56.LANG_ID,
T56.MODIFICATION_NUM,
T10.ROW_ID,
T10.TYPE,
T10.LANG_ID,
T10.MODIFICATION_NUM,
T5.ROW_ID,
T5.TYPE,
T5.LANG_ID,
T5.MODIFICATION_NUM,
T7.ROW_ID,
T7.TYPE,
T7.LANG_ID,
T7.MODIFICATION_NUM,
T37.ROW_ID,
T37.TYPE,
T37.LANG_ID,
T37.MODIFICATION_NUM,
T65.ROW_ID,
T65.TYPE,
T65.LANG_ID,
T65.MODIFICATION_NUM,
T32.ROW_ID,
T32.TYPE,
T32.LANG_ID,
T32.MODIFICATION_NUM,
T18.ROW_ID,
T18.TYPE,
T18.LANG_ID,
T18.MODIFICATION_NUM,
T62.ROW_ID,
T62.TYPE,
T62.LANG_ID,
T62.MODIFICATION_NUM,
T31.ROW_ID,
T31.TYPE,
T31.LANG_ID,
T31.MODIFICATION_NUM,
T14.ROW_ID,
T14.TYPE,
T14.LANG_ID,
T14.MODIFICATION_NUM,
T1.ROW_ID,
T1.TYPE,
T1.LANG_ID,
T1.MODIFICATION_NUM,
T55.ROW_ID,
T55.TYPE,
T55.LANG_ID,
T55.MODIFICATION_NUM,
T44.ROW_ID,
T44.TYPE,
T44.LANG_ID,
T44.MODIFICATION_NUM,
T33.ROW_ID,
T33.TYPE,
T33.LANG_ID,
T33.MODIFICATION_NUM,
T43.ROW_ID,
T43.TYPE,
T43.LANG_ID,
T43.MODIFICATION_NUM,
T38.ROW_ID,
T38.TYPE,
T38.LANG_ID,
T38.MODIFICATION_NUM,
T64.ROW_ID,
T64.TYPE,
T64.LANG_ID,
T64.MODIFICATION_NUM,
T34.ROW_ID,
T34.TYPE,
T34.LANG_ID,
T34.MODIFICATION_NUM,
T50.ROW_ID,
T50.TYPE,
T50.LANG_ID,
T50.MODIFICATION_NUM,
T45.ROW_ID,
T45.TYPE,
T45.LANG_ID,
T45.MODIFICATION_NUM,
T51.ROW_ID,
T51.TYPE,
T51.LANG_ID,
T51.MODIFICATION_NUM,
T24.ROW_ID,
T24.TYPE,
T24.LANG_ID,
T24.MODIFICATION_NUM,
T8.ROW_ID,
T8.TYPE,
T8.LANG_ID,
T8.MODIFICATION_NUM,
T2.ROW_ID,
T2.TYPE,
T2.LANG_ID,
T2.MODIFICATION_NUM,
T19.ROW_ID,
T19.TYPE,
T19.LANG_ID,
T19.MODIFICATION_NUM,
T20.ROW_ID,
T20.TYPE,
T20.LANG_ID,
T20.MODIFICATION_NUM,
T13.ROW_ID,
T13.TYPE,
T13.LANG_ID,
T13.MODIFICATION_NUM,
T22.ROW_ID,
T22.TYPE,
T22.LANG_ID,
T22.MODIFICATION_NUM,
T57.ROW_ID,
T57.TYPE,
T57.LANG_ID,
T57.MODIFICATION_NUM,
T47.ROW_ID,
T47.TYPE,
T47.LANG_ID,
T47.MODIFICATION_NUM,
T35.ROW_ID,
T35.TYPE,
T35.LANG_ID,
T35.MODIFICATION_NUM,
T53.ROW_ID,
T53.TYPE,
T53.LANG_ID,
T53.MODIFICATION_NUM,
T58.ROW_ID,
T58.TYPE,
T58.LANG_ID,
T58.MODIFICATION_NUM,
T49.ROW_ID,
T49.TYPE,
T49.LANG_ID,
T49.MODIFICATION_NUM,
T40.ROW_ID,
T40.TYPE,
T40.LANG_ID,
T40.MODIFICATION_NUM,
T26.ROW_ID,
T26.TYPE,
T26.LANG_ID,
T26.MODIFICATION_NUM,
T4.ROW_ID,
T4.TYPE,
T4.LANG_ID,
T4.MODIFICATION_NUM
FROM
UCMD.S_LST_OF_VAL T1,
UCMD.S_LST_OF_VAL T2,
UCMD.S_ORG_EXT T3,
UCMD.S_LST_OF_VAL T4,
UCMD.S_LST_OF_VAL T5,
UCMD.S_LST_OF_VAL T6,
UCMD.S_LST_OF_VAL T7,
UCMD.S_LST_OF_VAL T8,
UCMD.S_LST_OF_VAL T9,
UCMD.S_LST_OF_VAL T10,
UCMD.S_LST_OF_VAL T11,
UCMD.S_LST_OF_VAL T12,
UCMD.S_LST_OF_VAL T13,
UCMD.S_LST_OF_VAL T14,
UCMD.S_LST_OF_VAL T15,
UCMD.S_LST_OF_VAL T16,
UCMD.S_LST_OF_VAL T17,
UCMD.S_LST_OF_VAL T18,
UCMD.S_LST_OF_VAL T19,
UCMD.S_LST_OF_VAL T20,
UCMD.S_LST_OF_VAL T21,
UCMD.S_LST_OF_VAL T22,
UCMD.S_LST_OF_VAL T23,
UCMD.S_LST_OF_VAL T24,
UCMD.S_CIF_EXT_SYST T25,
UCMD.S_LST_OF_VAL T26,
UCMD.S_LST_OF_VAL T27,
UCMD.S_LST_OF_VAL T28,
UCMD.S_LST_OF_VAL T29,
UCMD.S_LST_OF_VAL T30,
UCMD.S_LST_OF_VAL T31,
UCMD.S_LST_OF_VAL T32,
UCMD.S_LST_OF_VAL T33,
UCMD.S_LST_OF_VAL T34,
UCMD.S_LST_OF_VAL T35,
UCMD.S_LST_OF_VAL T36,
UCMD.S_LST_OF_VAL T37,
UCMD.S_LST_OF_VAL T38,
UCMD.S_LST_OF_VAL T39,
UCMD.S_LST_OF_VAL T40,
UCMD.S_LST_OF_VAL T41,
UCMD.S_LST_OF_VAL T42,
UCMD.S_LST_OF_VAL T43,
UCMD.S_LST_OF_VAL T44,
UCMD.S_LST_OF_VAL T45,
UCMD.S_LST_OF_VAL T46,
UCMD.S_LST_OF_VAL T47,
UCMD.S_LST_OF_VAL T48,
UCMD.S_LST_OF_VAL T49,
UCMD.S_LST_OF_VAL T50,
UCMD.S_LST_OF_VAL T51,
UCMD.S_LST_OF_VAL T52,
UCMD.S_LST_OF_VAL T53,
UCMD.S_LST_OF_VAL T54,
UCMD.S_LST_OF_VAL T55,
UCMD.S_LST_OF_VAL T56,
UCMD.S_LST_OF_VAL T57,
UCMD.S_LST_OF_VAL T58,
UCMD.S_LST_OF_VAL T59,
UCMD.S_LST_OF_VAL T60,
UCMD.S_LST_OF_VAL T61,
UCMD.S_LST_OF_VAL T62,
UCMD.S_LST_OF_VAL T63,
UCMD.S_LST_OF_VAL T64,
UCMD.S_LST_OF_VAL T65,
UCMD.S_LST_OF_VAL T66,
UCMD.S_UCM_CONTACT T67
WHERE
T67.EXT_SYST_ID = T25.ROW_ID (+) AND
T67.PR_DEPT_OU_ID = T3.PAR_ROW_ID (+) AND
T67.CALL_FREQUENCY = T15.NAME (+) AND T15.TYPE (+) = 'PROF_CALL_CLASS' AND T15.LANG_ID (+) = :1 AND
T67.CONTACT_PREF_CD = T39.NAME (+) AND T39.TYPE (+) = 'TODO_TYPE' AND T39.LANG_ID (+) = :2 AND
T67.DR_LICENSE_STATE = T6.NAME (+) AND T6.TYPE (+) = 'STATE_ABBREV' AND T6.LANG_ID (+) = :3 AND
T67.DFLT_ROLE_CD = T52.NAME (+) AND T52.TYPE (+) = 'CONTACT_ROLE' AND T52.LANG_ID (+) = :4 AND
T67.DEGREE = T23.NAME (+) AND T23.TYPE (+) = 'PROF_DEGREE' AND T23.LANG_ID (+) = :5 AND
T67.ELIGIBLE_DSCNT_CD = T48.NAME (+) AND T48.TYPE (+) = 'EAUTO_DISCOUNT_CD' AND T48.LANG_ID (+) = :6 AND
T67.EMAIL_LOC_CD = T46.NAME (+) AND T46.TYPE (+) = 'FIN_EMAIL_USAGE' AND T46.LANG_ID (+) = :7 AND
T67.ALT_EMAIL_LOC_CD = T21.NAME (+) AND T21.TYPE (+) = 'FIN_EMAIL_USAGE' AND T21.LANG_ID (+) = :8 AND
T67.INVST_HORIZ_CD = T17.NAME (+) AND T17.TYPE (+) = 'FINS_INV_HORIZON' AND T17.LANG_ID (+) = :9 AND
T67.INVST_EXPR_CD = T11.NAME (+) AND T11.TYPE (+) = 'FINS_INVST_EXPR_CD' AND T11.LANG_ID (+) = :10 AND
T67.INVST_PROFILE_CD = T29.NAME (+) AND T29.TYPE (+) = 'FINS_INVST_PROFILE_CD' AND T29.LANG_ID (+) = :11 AND
T67.MARITAL_STAT_CD = T16.NAME (+) AND T16.TYPE (+) = 'MARITAL_STATUS' AND T16.LANG_ID (+) = :12 AND
T67.PREF_COMM_MEDIA_CD = T28.NAME (+) AND T28.TYPE (+) = 'OFFER_MEDIA' AND T28.LANG_ID (+) = :13 AND
T67.RMNDR_COMM_METH_CD = T59.NAME (+) AND T59.TYPE (+) = 'COMM_METHOD' AND T59.LANG_ID (+) = :14 AND
T67.PREF_LANG_ID = T60.NAME (+) AND T60.TYPE (+) = 'CONTACT_LANGUAGE' AND T60.LANG_ID (+) = :15 AND
T67.FLWUP_COMM_METH_CD = T54.NAME (+) AND T54.TYPE (+) = 'COMM_METHOD' AND T54.LANG_ID (+) = :16 AND
T67.PR_COUNTRY = T66.NAME (+) AND T66.TYPE (+) = 'COUNTRY' AND T66.LANG_ID (+) = :17 AND
T67.PRIVACY_CD = T42.NAME (+) AND T42.TYPE (+) = 'PRIVACY_CODE' AND T42.LANG_ID (+) = :18 AND
T67.STAT_REASON_CD = T27.NAME (+) AND T27.TYPE (+) = 'FINS_LEAVING_REASON_TYPE' AND T27.LANG_ID (+) = :19 AND
T67.RELIABILITY_CD = T12.NAME (+) AND T12.TYPE (+) = 'PUB_HLS_CON_RELIABILITY' AND T12.LANG_ID (+) = :20 AND
T67.REWARD_LVL_CD = T41.NAME (+) AND T41.TYPE (+) = 'TNT_SHM_REWARD_LEVEL' AND T41.LANG_ID (+) = :21 AND
T67.CUST_STAT_CD = T63.NAME (+) AND T63.TYPE (+) = 'CONTACT_STATUS' AND T63.LANG_ID (+) = :22 AND
T67.PER_TITLE_SUFFIX = T61.NAME (+) AND T61.TYPE (+) = 'FINS_SUFFIX_MLOV' AND T61.LANG_ID (+) = :23 AND
T67.UCM_TYPE_CD = T30.NAME (+) AND T30.TYPE (+) = 'UCM_SDH_TYPE_MLOV' AND T30.LANG_ID (+) = :24 AND
T67.TMZONE_CD = T9.NAME (+) AND T9.TYPE (+) = 'TIMEZONE' AND T9.LANG_ID (+) = :25 AND
T67.CON_CD = T36.NAME (+) AND T36.TYPE (+) = 'CONTACT_TYPE' AND T36.LANG_ID (+) = :26 AND
T67.PR_COUNTRY = T56.NAME (+) AND T56.TYPE (+) = 'COUNTRY' AND T56.LANG_ID (+) = :27 AND
T67.NATIONALITY = T10.NAME (+) AND T10.TYPE (+) = 'FIN_CON_CITIZENSHIP' AND T10.LANG_ID (+) = :28 AND
T67.COM_PREFERENCE = T5.NAME (+) AND T5.TYPE (+) = 'FINCORP_CONTACT_CORR_PREF' AND T5.LANG_ID (+) = :29 AND
T67.CITIZENSHIP_CD = T7.NAME (+) AND T7.TYPE (+) = 'FIN_CON_CITIZENSHIP' AND T7.LANG_ID (+) = :30 AND
T67.INVST_KNWLDG_CD = T37.NAME (+) AND T37.TYPE (+) = 'FINS_INVST_KNWLDG_CD' AND T37.LANG_ID (+) = :31 AND
T67.INVST_RISK_CD = T65.NAME (+) AND T65.TYPE (+) = 'FINS_INVST_RISK_CD' AND T65.LANG_ID (+) = :32 AND
T67.SEX_MF = T32.NAME (+) AND T32.TYPE (+) = 'SEX_MF' AND T32.LANG_ID (+) = :33 AND
T67.PER_TITLE = T18.NAME (+) AND T18.TYPE (+) = 'MR_MS' AND T18.LANG_ID (+) = :34 AND
T67.IDEN2_TYPE_CD = T62.NAME (+) AND T62.TYPE (+) = 'FINS_GTR_ID_TYPE' AND T62.LANG_ID (+) = :35 AND
T67.PREF_COMM_METH_CD = T31.NAME (+) AND T31.TYPE (+) = 'COMM_METHOD' AND T31.LANG_ID (+) = :36 AND
T67.X_CORRESPONDENCE_LANG_CODE = T14.NAME (+) AND T14.TYPE (+) = 'UCM_LANGUAGE' AND T14.LANG_ID (+) = :37 AND
T67.X_CURRENT_PACKAGE = T1.NAME (+) AND T1.TYPE (+) = 'UCM_PACKAGES' AND T1.LANG_ID (+) = :38 AND
T67.X_EDU_CD = T55.NAME (+) AND T55.TYPE (+) = 'EDUCATION_LEVEL' AND T55.LANG_ID (+) = :39 AND
T67.X_EMPLMNT_STAT_CD = T44.NAME (+) AND T44.TYPE (+) = 'EMPLOYMENT_STATUS' AND T44.LANG_ID (+) = :40 AND
T67.X_FAX_PHONE_PREF_TIME_TO_CALL = T33.NAME (+) AND T33.TYPE (+) = 'FINCORP_CONTACT_CALL_TIME' AND T33.LANG_ID (+) = :41 AND
T67.X_FINANCIAL_INSTITUTION_TYPE = T43.NAME (+) AND T43.TYPE (+) = 'UCM_FINANCIAL_INSTITUTION_TYPE' AND T43.LANG_ID (+) = :42 AND
T67.X_FROZEN_FLG = T38.NAME (+) AND T38.TYPE (+) = 'UCM_FROZEN_FLAG' AND T38.LANG_ID (+) = :43 AND
T67.X_HOME_PHONE_PREF_TIME_TO_CALL = T64.NAME (+) AND T64.TYPE (+) = 'FINCORP_CONTACT_CALL_TIME' AND T64.LANG_ID (+) = :44 AND
T67.X_IDEN_TYPE_CD = T34.NAME (+) AND T34.TYPE (+) = 'FIN_CON_ID_TYPE' AND T34.LANG_ID (+) = :45 AND
T67.X_IDEN_COUNTRY_CD = T50.NAME (+) AND T50.TYPE (+) = 'COUNTRY' AND T50.LANG_ID (+) = :46 AND
T67.X_MARKET_SECTOR = T45.NAME (+) AND T45.TYPE (+) = 'UCM_RETAIL_MARKET_SECTOR' AND T45.LANG_ID (+) = :47 AND
T67.X_MIGRATED_FROM_PACKAGE = T51.NAME (+) AND T51.TYPE (+) = 'UCM_MIGRATED_FROM_PACKAGE' AND T51.LANG_ID (+) = :48 AND
T67.X_MOBILE_PREF_TIME_TO_CALL = T24.NAME (+) AND T24.TYPE (+) = 'FINCORP_CONTACT_CALL_TIME' AND T24.LANG_ID (+) = :49 AND
T67.X_MON_INCOME_CD = T8.NAME (+) AND T8.TYPE (+) = 'INCOME' AND T8.LANG_ID (+) = :50 AND
T67.X_IDEN2_COUNTRY_CD = T2.NAME (+) AND T2.TYPE (+) = 'COUNTRY' AND T2.LANG_ID (+) = :51 AND
T67.X_RESIDENCE_TYPE = T19.NAME (+) AND T19.TYPE (+) = 'FIN_HOUSING_TYPE' AND T19.LANG_ID (+) = :52 AND
T67.X_PARTY_TYPE_CODE = T20.NAME (+) AND T20.TYPE (+) = 'UCM_PARTY_TYPE_CODE' AND T20.LANG_ID (+) = :53 AND
T67.X_PREFERRED_BILL_DELIVERY_TYPE = T13.NAME (+) AND T13.TYPE (+) = 'FINS_BA_BILL_MEDIUM' AND T13.LANG_ID (+) = :54 AND
T67.X_POSTN_CD = T22.NAME (+) AND T22.TYPE (+) = 'POSITION_TYPE' AND T22.LANG_ID (+) = :55 AND
T67.X_RECOMMENDED_PACKAGE = T57.NAME (+) AND T57.TYPE (+) = 'UCM_RECOMMENDED_PACKAGE' AND T57.LANG_ID (+) = :56 AND
T67.X_REQUESTED_PACKAGE = T47.NAME (+) AND T47.TYPE (+) = 'UCM_REQUESTED_PACKAGE' AND T47.LANG_ID (+) = :57 AND
T67.X_SAMA_CLASS = T35.NAME (+) AND T35.TYPE (+) = 'UCM_SAMA_CLSS' AND T35.LANG_ID (+) = :58 AND
T67.X_SENSITIVITY_DEGREE = T53.NAME (+) AND T53.TYPE (+) = 'HLS_CASE_CLASSIFICATION' AND T53.LANG_ID (+) = :59 AND
T67.X_SPEND_PREFERENCE = T58.NAME (+) AND T58.TYPE (+) = 'UCM_SPEND_PREFERENCE' AND T58.LANG_ID (+) = :60 AND
T67.X_CUST_STATUS_CHANGE_METHOD = T49.NAME (+) AND T49.TYPE (+) = 'UCM_CUST_STATUS_CHANGE_METHOD' AND T49.LANG_ID (+) = :61 AND
T67.X_VIP = T40.NAME (+) AND T40.TYPE (+) = 'UCM_VIP' AND T40.LANG_ID (+) = :62 AND
T67.X_WORK_PHONE_PREF_TIME_TO_CALL = T26.NAME (+) AND T26.TYPE (+) = 'FINCORP_CONTACT_CALL_TIME' AND T26.LANG_ID (+) = :63 AND
T67.X_ECONOMIC_SECTOR = T4.NAME (+) AND T4.TYPE (+) = 'UCM_ECONOMIC_SECTOR' AND T4.LANG_ID (+) = :64 AND
(T67.ROW_ID = :65)
ORDER BY
T67.UCM_UID

[Amgad]

الأخ / العزيز

بصراحة ليس لدى رأى فى كيفية تحسين الاداء .. وان كنت اقترح البحث فى موضوع ال Index لحقول الربط بين الجداول ..

لى سؤالين بخصوص امر ال join السابق عرضه
- كيف تمت كتابة هذه الjoin الكبيرة .
- اريد ان اعرف فقط من وجهه نظر التحليل .. ما هى نوعيه هذه البيانات والجداول واهميه الروابط .. اريد فكرة مبسطه فقط .

عموما .. انتظر رد الاخوه الزملاء .. فى سؤالك

شكرا لك

[samir khalil]

اخي العزيز
يوجد عندنا برنامج اسمه sieble وهو الذي craete هذه الجمله

[محمد سعيد]

السلام عليكم
نرجو وضع الجدول المبنية عليه الجملة لنتمكن من التجريب