Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select Query Times out.

The execution plan from ST05 is pasted below:

SELECT

  T_01."RUN_DATE",T_01."RUN_ID",T_01."OWN_NO",T_01."OWN_SEQ_NO",T_00."BA_NM_1",T_01."STATUS",

  T_01."STATUS",T_01."CHECK_NO",T_03."CR_CK_DT",T_03."CR_CK_STS_CD",T_03."CR_CK_STS_CD",

  T_02."LINE_NO",T_02."ORG_LVL_1",T_02."TRACE_CO_NO",T_02."BTCH_TYPE_CD",T_02."ACCT_NO",

  T_02."PD_CD",T_02."VL_TYPE_CD",T_02."VL_CLASS_CD",T_02."VL_SRCE_CD",T_02."VL_FRQ_CD",

  T_02."MMBTU_DET_CD",T_02."SA_DT",T_02."STATE_CD",T_02."PAY_CD",T_02."LGND_CD",T_02."PU_NO",

  T_02."PU_SEQ_NO",T_02."PRDR_NO",T_02."PRDR_SEQ_NO",T_02."OWN_BAL_DECM_QY",T_02."OWN_INT_DECM_QY",

  T_02."OWN_INT_TYPE_CD",T_02."OWN_INT_SEQ_NO",T_02."UNIT_OF_MEAS_CD",T_02."SUS_RSN_CD",

  T_02."CT_NO",T_02."CT_TYPE_CD",T_02."DOI_PR_NO",T_02."DOI_SEQ_NO",T_02."SECT_PR_NO",

  T_02."SECT_SEQ_NO",T_02."UNIT_PR_NO",T_02."NWK_NO",T_02."SUBNWK_NO",T_02."SA_MP_NO",T_02."WL_NO",

  T_02."WC_NO",T_02."PHASE_NO",T_02."TRANS_AM",T_02."TRANS_QY",T_02."GR_AM",T_02."GR_QY",

  T_02."DED_RMB_AM",T_02."DED_GR_RMB_AM",T_02."TAX_CD",T_02."TAX_1_AM",T_02."TAX_2_AM",

  T_02."TAX_3_AM",T_02."TAX_4_AM",T_02."TAX_5_AM",T_02."TAX_6_AM",T_02."TAX_7_AM",T_02."TAX_8_AM",

  T_02."TAX_9_AM",T_02."TAX_10_AM",T_02."TAX_RMB_AM",T_02."TAX_GR_RMB_AM",T_02."GR_TAX_1_AM",

  T_02."GR_TAX_2_AM",T_02."GR_TAX_3_AM",T_02."GR_TAX_4_AM",T_02."GR_TAX_5_AM",T_02."GR_TAX_6_AM",

  T_02."GR_TAX_7_AM",T_02."GR_TAX_8_AM",T_02."GR_TAX_9_AM",T_02."GR_TAX_10_AM",T_02."NET_TRANSP_AM",

  T_02."NET_OTH_MK_AM",T_02."GR_TRANSP_AM",T_02."GR_OTH_MK_AM",T_02."OTH_DED_01_AM",

  T_02."OTH_DED_02_AM",T_02."OTH_DED_03_AM",T_02."OTH_DED_04_AM",T_02."OTH_DED_05_AM",

  T_02."OTH_DED_06_AM",T_02."OTH_DED_07_AM",T_02."OTH_DED_08_AM",T_02."OTH_DED_09_AM",

  T_02."OTH_DED_10_AM",T_02."OTH_DED_11_AM",T_02."OTH_DED_12_AM",T_02."OTH_DED_13_AM",

  T_02."OTH_DED_14_AM",T_02."OTH_DED_15_AM",T_02."OTH_DED_16_AM",T_02."OTH_DED_17_AM",

  T_02."OTH_DED_18_AM",T_02."TXN_VAL_AM",T_02."PLT_VL_GRED_AM",T_02."PLT_VL_ORED_AM",

  T_02."MMBTU_OVL_AM",T_02."MMBTU_GRVL_AM"

FROM

  "OIUH_CM_BA" T_00 INNER JOIN "OIUCW_OWNER_SEQ" T_01 ON T_01."MANDT"=:A0 AND T_00."BA_BA_NO"=T_01."

  OWN_NO" AND T_00."BA_SEQ_NO"=T_01."OWN_SEQ_NO" INNER JOIN "OIUCW_PAYMENT" T_02 ON T_02."MANDT"=:A1

   AND T_01."RUN_ID"=T_02."RUN_ID" AND T_01."RUN_DATE"=T_02."RUN_DATE" AND T_01."OWN_NO"=T_02."OWN_N

  O" AND T_01."OWN_SEQ_NO"=T_02."OWN_SEQ_NO" INNER JOIN "OIUH_RV_CR" T_03 ON T_03."MANDT"=:A2 AND T_

  01."CHECK_NO"=T_03."CR_CK_NO" AND T_01."OWN_NO"=T_03."CR_PYE_NO" AND T_01."OWN_SEQ_NO"=T_03."CR_PY

  E_SEQ_NO"

WHERE

  T_00."MANDT"=:A3 AND T_00."BA_BA_NO"=:A4 AND T_00."BA_SEQ_NO"=:A5 AND T_02."ORG_LVL_1"=:A6 AND

(T_03."CR_CK_STS_CD"=:A7 OR T_03."CR_CK_STS_CD"=:A8 OR T_03."CR_CK_STS_CD"=:A9

T_03."CR_CK_STS_CD"=:A10 OR T_03."CR_CK_STS_CD"=:A11) AND T_03."CR_CK_DT" BETW

OR T_00."MANDT"=:A14 AND T_00."BA_BA_NO"=:A15 AND T_00."BA_SEQ_NO"=:A16 AND T_

AND (T_03."CR_CK_STS_CD"=:A18 OR T_03."CR_CK_STS_CD"=:A19 OR T_03."CR_CK_STS_C

T_03."CR_CK_STS_CD"=:A21 OR T_03."CR_CK_STS_CD"=:A22) AND T_03."CR_CK_DT" BETW

OR T_00."MANDT"=:A25 AND T_00."BA_BA_NO"=:A26 AND T_00."BA_SEQ_NO"=:A27 AND T_

AND (T_03."CR_CK_STS_CD"=:A29 OR T_03."CR_CK_STS_CD"=:A30 OR T_03."CR_CK_STS_C

T_03."CR_CK_STS_CD"=:A32 OR T_03."CR_CK_STS_CD"=:A33) AND T_03."CR_CK_DT" BETW

OR T_00."MANDT"=:A36 AND T_00."BA_BA_NO"=:A37 AND T_00."BA_SEQ_NO"=:A38 AND T_

AND (T_03."CR_CK_STS_CD"=:A40 OR T_03."CR_CK_STS_CD"=:A41 OR T_03."CR_CK_STS_C

T_03."CR_CK_STS_CD"=:A43 OR T_03."CR_CK_STS_CD"=:A44) AND T_03."CR_CK_DT" BETW

OR T_00."MANDT"=:A47 AND T_00."BA_BA_NO"=:A48 AND T_00."BA_SEQ_NO"=:A49 AND T_

AND (T_03."CR_CK_STS_CD"=:A51 OR T_03."CR_CK_STS_CD"=:A52 OR T_03."CR_CK_STS_C

T_03."CR_CK_STS_CD"=:A54 OR T_03."CR_CK_STS_CD"=:A55) AND T_03."CR_CK_DT" BETW

execution Plan

SELECT STATEMENT ( Estimated Costs = 2.146 , Estimated #Rows = 5 )

      56 CONCATENATION

          11 NESTED LOOPS

              9 NESTED LOOPS

                ( Estim. Costs = 429 , Estim. #Rows = 1 )

                Estim. CPU-Costs = 143.891.166 Estim. IO-Costs = 413

                  7 NESTED LOOPS

                    ( Estim. Costs = 428 , Estim. #Rows = 1 )

                    Estim. CPU-Costs = 143.884.827 Estim. IO-Costs = 413

4 NESTED LOOPS

   ( Estim. Costs = 424 , Estim. #Rows = 7 )

   Estim. CPU-Costs = 143.851.663 Estim. IO-Costs = 408

     2 TABLE ACCESS BY INDEX ROWID OIUH_CM_BA

       Estim. CPU-Costs = 3.105 Estim. IO-Costs = 0

         1 INDEX UNIQUE SCAN OIUH_CM_BA~0

           Search Columns: 3

           Estim. CPU-Costs = 1.634 Estim. IO-Costs = 0

           Access Predicates

     3 TABLE ACCESS FULL OIUCW_OWNER_SEQ

       ( Estim. Costs = 424 , Estim. #Rows = 7 )

       Estim. CPU-Costs = 143.848.559 Estim. IO-Costs = 408

       Filter Predicates

6 TABLE ACCESS BY INDEX ROWID OIUH_RV_CR

   ( Estim. Costs = 1 , Estim. #Rows = 1 )

   Estim. CPU-Costs = 4.738 Estim. IO-Costs = 1

   Filter Predicates

     5 INDEX RANGE SCAN OIUH_RV_CR~I03

       Search Columns: 2

       Estim. CPU-Costs = 3.099 Estim. IO-Costs = 0

       Access Predicates

INDEX RANGE SCAN OIUCW_PAYMENT~0

Estim. Costs = 1 , Estim. #Rows = 1 )

earch Columns: 5

stim. CPU-Costs = 4.483 Estim. IO-Costs = 1

ccess Predicates

Former Member
Not what you were looking for? View more on this topic or Ask a question