إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

Sql Statment Problem


3 رد (ردود) على هذا الموضوع

#1 samir khalil

samir khalil

    عضو

  • الأعضــاء
  • 13 مشاركة

تاريخ المشاركة 06 September 2007 - 02:07 PM

السلام عليكم
عندي جملة 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

#2 Amgad

Amgad

    مشرف عام ومشرف قسم تحليل النظم

  • الفريق الإداري
  • 4,557 مشاركة
  • الاسم الأول:امجد
  • اسم العائلة:حلمي
  • البـلـد: Country Flag
  • المنصب الحالي:Business Systems Analyst at al Fanar Co. Riyadh KSA

تاريخ المشاركة 06 September 2007 - 07:38 PM

الأخ / العزيز

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

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

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

شكرا لك

لا إله إلا الله الحليم الكريم
لا اله إلا الله العلى العظيم
لا اله إلا الله رب السماوات السبع و رب العرش العظيم
‏اللهم ارزقني قبل الموت توبة وعند الموت شهادة وبعد الموت جنة
اللهم ارزقني حسن الخاتمة
اللهم هون علينا سكرات الموت ... ونور علينا قبورنا
اللهم ارزقني الموت وأنا ساجد لك يا ارحم الراحمين
اللهم ثبتني عند سؤال الملكين
اللهم اجعل قبري روضة من رياض الجنة ولا تجعله حفرة من حفر النار
اللهم اني اعوذ بك من فتن الدنيا
اللهم ارحم ابائنا وامهاتنا واغفر لهما وتجاوز عن سيئاتهما وادخلهم فسيح جناتك ... والحقنا بهما يا رب العالمين
اللهم ارحم موتانا وموتى المسلمين واشفي مرضانا ومرضى المسلمين
اللهم اغفر للمسلمين والمسلمات والمؤمنين والمؤمنات الأحياء منهم والأموات
وبارك اللهم على سيدنا محمد صلى الله عليه وسلم
اللهم آمين ... اللهم آمين ... اللهم آمين


....


#3 samir khalil

samir khalil

    عضو

  • الأعضــاء
  • 13 مشاركة

تاريخ المشاركة 07 September 2007 - 11:58 PM

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

#4 محمد سعيد

محمد سعيد

    عضو مميز

  • الأعضــاء
  • 534 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 08 September 2007 - 06:35 PM

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