**********************daily report****************************************************************** ----------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | ----------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 533 | 3292 | | 1 | FILTER | | | | | | 2 | SORT GROUP BY | | 1 | 533 | 3292 | | 3 | FILTER | | | | | | 4 | PX COORDINATOR | | | | | | 5 | PX SEND QC (RANDOM) | :TQ10006 | 1 | 533 | 3587 | | 6 | NESTED LOOPS | | 1 | 533 | 3587 | | 7 | NESTED LOOPS | | 1 | 496 | 3584 | | 8 | NESTED LOOPS | | 1 | 451 | 3583 | | 9 | NESTED LOOPS | | 1 | 428 | 3582 | | 10 | NESTED LOOPS | | 1 | 392 | 3580 | | 11 | NESTED LOOPS | | 1 | 358 | 3578 | | 12 | NESTED LOOPS | | 1 | 315 | 3576 | | 13 | HASH JOIN | | 31 | 7998 | 3483 | | 14 | HASH JOIN | | 31 | 7409 | 3478 | | 15 | HASH JOIN | | 31 | 6417 | 3473 | | 16 | HASH JOIN | | 31 | 5177 | 3468 | | 17 | BUFFER SORT | | | | | | 18 | PX RECEIVE | | 125K| 10M| 1691 | | 19 | PX SEND BROADCAST | :TQ10000 | 125K| 10M| 1691 | | 20 | TABLE ACCESS FULL | LDTB_CONTRACT_MASTER | 125K| 10M| 1691 | | 21 | HASH JOIN | | 3223K| 248M| 1630 | | 22 | PX RECEIVE | | 114K| 2229K| 144 | | 23 | PX SEND HASH | :TQ10005 | 114K| 2229K| 144 | | 24 | PX BLOCK ITERATOR | | 114K| 2229K| 144 | | 25 | INDEX FAST FULL SCAN| IND01_LDTB_CON_BALANCE | 114K| 2229K| 144 | | 26 | BUFFER SORT | | | | | | 27 | PX RECEIVE | | 3223K| 187M| 1341 | | 28 | PX SEND HASH | :TQ10001 | 3223K| 187M| 1341 | | 29 | HASH JOIN | | 3223K| 187M| 1341 | | 30 | TABLE ACCESS FULL | TATM_SLAB | 88 | 2024 | 3 | | 31 | TABLE ACCESS FULL | TATB_TXNRULE | 219K| 8155K| 1200 | | 32 | BUFFER SORT | | | | | | 33 | PX RECEIVE | | 38 | 1520 | 3 | | 34 | PX SEND BROADCAST | :TQ10002 | 38 | 1520 | 3 | | 35 | TABLE ACCESS FULL | STTM_BRANCH | 38 | 1520 | 3 | | 36 | BUFFER SORT | | | | | | 37 | PX RECEIVE | | 38 | 1216 | 3 | | 38 | PX SEND BROADCAST | :TQ10003 | 38 | 1216 | 3 | | 39 | TABLE ACCESS FULL | STTM_DATES | 38 | 1216 | 3 | | 40 | BUFFER SORT | | | | | | 41 | PX RECEIVE | | 93 | 1767 | 3 | | 42 | PX SEND BROADCAST | :TQ10004 | 93 | 1767 | 3 | | 43 | TABLE ACCESS FULL | LDTM_PRODUCT_MASTER | 93 | 1767 | 3 | | 44 | TABLE ACCESS BY INDEX ROWID | CFTB_CONTRACT_INTEREST | 1 | 57 | 3 | | 45 | INDEX RANGE SCAN | IND_INT_CRN_COMP_ESN | 1 | | 2 | | 46 | TABLE ACCESS BY INDEX ROWID | CSTB_CONTRACT | 1 | 43 | 2 | | 47 | INDEX UNIQUE SCAN | CC1_PK | 1 | | 1 | | 48 | SORT AGGREGATE | | 1 | 21 | | | 49 | INDEX RANGE SCAN | IND_INT_CRN_COMP_ESN | 1 | 21 | 3 | | 50 | TABLE ACCESS BY INDEX ROWID | LDTB_CONTRACT_PREFERENCE | 1 | 34 | 2 | | 51 | INDEX UNIQUE SCAN | CP1_PK | 1 | | 1 | | 52 | INDEX RANGE SCAN | PK_TATB_TXNRULE_DETAIL | 1 | 36 | 2 | | 53 | TABLE ACCESS BY INDEX ROWID | MITM_CUSTOMER_DEFAULT | 1 | 23 | 1 | | 54 | INDEX UNIQUE SCAN | PK_CUSTOMER_DEFAULT | 1 | | 0 | | 55 | TABLE ACCESS BY INDEX ROWID | STTM_CUSTOMER | 1 | 45 | 1 | | 56 | INDEX UNIQUE SCAN | SYS_C00123717 | 1 | | 0 | | 57 | INDEX RANGE SCAN | CM_PK | 1 | 37 | 2 | | 58 | TABLE ACCESS BY INDEX ROWID | CSTB_AMOUNT_DUE | 1 | 37 | 4 | | 59 | INDEX RANGE SCAN | DUE_PK1 | 1 | | 3 | ----------------------------------------------------------------------------------------------------- ***********************summary report***************************************************************** --------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | --------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 72 | 10706 | | 1 | SORT GROUP BY NOSORT | | 1 | 72 | 10706 | | 2 | VIEW | | 1 | 72 | 10705 | | 3 | FILTER | | | | | | 4 | SORT GROUP BY | | 1 | 468 | | | 5 | CONCATENATION | | | | | | 6 | FILTER | | | | | | 7 | NESTED LOOPS | | 4 | 1872 | 126 | | 8 | NESTED LOOPS | | 3 | 1290 | 120 | | 9 | NESTED LOOPS | | 3 | 954 | 114 | | 10 | NESTED LOOPS | | 3 | 825 | 108 | | 11 | NESTED LOOPS | | 3 | 756 | 105 | | 12 | NESTED LOOPS | | 3 | 660 | 102 | | 13 | NESTED LOOPS | | 3 | 597 | 102 | | 14 | NESTED LOOPS | | 3 | 546 | 102 | | 15 | NESTED LOOPS | | 3 | 450 | 99 | | 16 | NESTED LOOPS | | 3 | 402 | 99 | | 17 | INDEX RANGE SCAN | IND01_LDTB_CON_BALANCE | 32 | 640 | 3 | | 18 | TABLE ACCESS BY INDEX ROWID | LDTB_CONTRACT_MASTER | 1 | 114 | 3 | | 19 | INDEX RANGE SCAN | CM_PK | 1 | | 2 | | 20 | SORT AGGREGATE | | 1 | 20 | | | 21 | FIRST ROW | | 1 | 20 | 3 | | 22 | INDEX RANGE SCAN (MIN/MAX)| CM_PK | 1 | 20 | 3 | | 23 | INDEX UNIQUE SCAN | SYS_C00123682 | 1 | 16 | 0 | | 24 | TABLE ACCESS BY INDEX ROWID | STTM_DATES | 1 | 32 | 1 | | 25 | INDEX UNIQUE SCAN | SYS_C00123757 | 1 | | 0 | | 26 | INDEX UNIQUE SCAN | LNPROD_PK | 1 | 17 | 0 | | 27 | INDEX UNIQUE SCAN | SYS_C00123717 | 1 | 21 | 0 | | 28 | INDEX UNIQUE SCAN | CP1_PK | 1 | 32 | 1 | | 29 | TABLE ACCESS BY INDEX ROWID | MITM_CUSTOMER_DEFAULT | 1 | 23 | 1 | | 30 | INDEX UNIQUE SCAN | PK_CUSTOMER_DEFAULT | 1 | | 0 | | 31 | INDEX RANGE SCAN | IND_INT_CRN_COMP_ESN | 1 | 43 | 2 | | 32 | TABLE ACCESS BY INDEX ROWID | CSTB_CONTRACT | 1 | 112 | 2 | | 33 | INDEX UNIQUE SCAN | CC1_PK | 1 | | 1 | | 34 | INDEX RANGE SCAN | IND_INT_CRN_COMP_ESN | 1 | 38 | 2 | | 35 | TABLE ACCESS BY INDEX ROWID | CSTB_AMOUNT_DUE | 1 | 37 | 4 | | 36 | INDEX RANGE SCAN | DUE_PK1 | 1 | | 3 | | 37 | FILTER | | | | | | 38 | NESTED LOOPS | | 187 | 87516 | 7124 | | 39 | HASH JOIN | | 145 | 62350 | 6833 | | 40 | NESTED LOOPS | | 145 | 59015 | 6726 | | 41 | NESTED LOOPS | | 145 | 55970 | 6726 | | 42 | HASH JOIN | | 145 | 39730 | 6435 | | 43 | NESTED LOOPS | | 147 | 37338 | 5933 | | 44 | HASH JOIN | | 147 | 32634 | 5785 | | 45 | HASH JOIN | | 10475 | 1831K| 4908 | | 46 | INDEX FULL SCAN | LNPROD_PK | 93 | 1581 | 1 | | 47 | HASH JOIN | | 10475 | 1657K| 4906 | | 48 | NESTED LOOPS | | 38 | 1824 | 3 | | 49 | TABLE ACCESS FULL | STTM_DATES | 38 | 1216 | 3 | | 50 | INDEX UNIQUE SCAN | SYS_C00123682 | 1 | 16 | 0 | | 51 | TABLE ACCESS BY INDEX ROWID | LDTB_CONTRACT_MASTER | 10475 | 1166K| 4902 | | 52 | INDEX FULL SCAN | CM_PK | 10475 | | 887 | | 53 | SORT AGGREGATE | | 1 | 20 | | | 54 | FIRST ROW | | 1 | 20 | 3 | | 55 | INDEX RANGE SCAN (MIN/MAX) | CM_PK | 1 | 20 | 3 | | 56 | INDEX FAST FULL SCAN | IND_INT_CRN_COMP_ESN | 147K| 6204K| 382 | | 57 | INDEX UNIQUE SCAN | CP1_PK | 1 | 32 | 1 | | 58 | INDEX RANGE SCAN | IND01_LDTB_CON_BALANCE | 112K| 2194K| 496 | | 59 | TABLE ACCESS BY INDEX ROWID | CSTB_CONTRACT | 1 | 112 | 2 | | 60 | INDEX UNIQUE SCAN | CC1_PK | 1 | | 1 | | 61 | INDEX UNIQUE SCAN | SYS_C00123717 | 1 | 21 | 0 | | 62 | TABLE ACCESS FULL | MITM_CUSTOMER_DEFAULT | 31465 | 706K| 106 | | 63 | INDEX RANGE SCAN | IND_INT_CRN_COMP_ESN | 1 | 38 | 2 | | 64 | TABLE ACCESS BY INDEX ROWID | CSTB_AMOUNT_DUE | 1 | 37 | 4 | | 65 | INDEX RANGE SCAN | DUE_PK1 | 1 | | 3 | ---------------------------------------------------------------------------------------------------------