Oracle Enterprise Manager
Oracle SQL Explain Plan 24 April 2007 19:05:07 GMT+00:00 

Target:

    DB001.CO

 

Version: Oracle 9.2.0.6.0

 

Database: DB001.CO

 

Schema: APLSYS

 

Date: 24-Apr-07 00:00:00


SQL Statement:

  
INSERT INTO fin_clubbing_logic
    (strclientcd, strfirstname, straddrline1, straddrline2, straddrline3, 
     strcountrycd, strstatecd, strtowncd, strpostalcd, strbasedocnbr, 
     strcashbankcd, strbankbranchcd, strbankacctnbr, strbrandcd, strvoutype, 
     strvouseries, lvounbr, nfiscalyear, nclub, dvouamnt)
((SELECT cpm.strclientcd, ccm.strfirstname, cca.straddrline1, cca.straddrline2, 
         cca.straddrline3, cca.strcountrycd, cca.strstatecd, cca.strtown, 
         cca.strpostalcd, fvh.strbasedocnbr, fvc.strcashbankcd, 
         fcm.strbankbranchcd, fcm.strbankacctnbr, fvc.strbrandcd, 
         fvc.strvoutype, fvc.strvouseries, fvh.lvounbr, fvc.nfiscalyear, 0, 
         sum(nvl(fvh.dvouamnt, 0))
      FROM fin_vou_hdr fvh, fin_vou_cshbnk fvc, com_client_m ccm, 
           com_client_address cca, fin_vou_pmt_dtl fcm, com_policy_m cpm
      WHERE fvh.strvoutype = fvc.strvoutype
        AND fvh.strvouseries = fvc.strvouseries
        AND fvh.lvounbr = fvc.lvounbr
        AND fvh.nfiscalyear = fvc.nfiscalyear
        AND fvh.strbrandcd = fvc.strbrandcd
        AND ccm.strclientcd = cca.strclientcd
        AND cpm.strclientcd = ccm.strclientcd
        AND fvh.strbasedocnbr = cpm.strpolnbr
        AND fvh.strvoutype = fcm.strvoutype
        AND fvh.strvouseries = fcm.strvouseries
        AND fvh.strbrandcd = fcm.strbrandcd
        AND fvh.nfiscalyear = fcm.nfiscalyear
        AND fvh.lvounbr = fcm.lvounbr
        AND cca.nisprimeaddr = 1
        AND fvh.strvoutype = 'PV'
        AND fvc.lpmtdtlseq IS NULL
        AND fvc.npmtreftype = 20
        AND fvh.strrefnbr IN (SELECT strrefnbr
                 FROM com_trans_int_hdr
                 WHERE lmoduleintmseqnbr IN (SELECT lmoduleintmseqnbr
                            FROM com_module_intm
                            WHERE nintmtype = 4
                              AND nintmto = 8)
                   AND nvl(nisvoupassed, 0) = 1
                   AND nvl(nvouind, 0) = 2)
        AND NOT fvh.strrefnbr IN (SELECT DISTINCT strclaimnbr
                 FROM clm_override_pymnts)
      GROUP BY fvh.strbasedocnbr, fvc.strcashbankcd, cpm.strclientcd, 
               ccm.strfirstname, cca.straddrline1, cca.straddrline2, 
               cca.straddrline3, cca.strcountrycd, cca.strpostalcd, cca.strtown, 
               cca.strstatecd, fcm.strbankbranchcd, fcm.strbankacctnbr, 
               fvc.strvoutype, fvc.strvouseries, fvc.strbrandcd, 
               fvc.nfiscalyear, fvh.lvounbr
  UNION 
  SELECT cpm.strclientcd, cop.strpayeename, cop.straddrline1, cop.straddrline2, 
         cop.straddrline3, cop.strcountrycd, cop.strstatecd, cop.strtown, 
         cop.strpostalcd, fvh.strbasedocnbr, fvc.strcashbankcd, 
         cop.strbankbranchcd, cop.strbankacctnbr, fvc.strbrandcd, 
         fvc.strvoutype, fvc.strvouseries, fvh.lvounbr, fvc.nfiscalyear, 
         decode(fvh.strbasedocnbr, 'Suspense', 0, 1), sum(nvl(fvh.dvouamnt, 0))
      FROM fin_vou_hdr fvh, fin_vou_cshbnk fvc, clm_override_pymnts cop, 
           fin_vou_pmt_dtl fcm, com_policy_m cpm
      WHERE fvh.strvoutype = fvc.strvoutype
        AND fvh.strvouseries = fvc.strvouseries
        AND fvh.lvounbr = fvc.lvounbr
        AND fvh.nfiscalyear = fvc.nfiscalyear
        AND fvh.strbrandcd = fvc.strbrandcd
        AND fvh.strvoutype = fcm.strvoutype
        AND fvh.strvouseries = fcm.strvouseries
        AND fvh.strbrandcd = fcm.strbrandcd
        AND fvh.nfiscalyear = fcm.nfiscalyear
        AND fvh.lvounbr = fcm.lvounbr
        AND cpm.strpolnbr = fvh.strbasedocnbr
        AND cop.strclaimnbr = fvh.strrefnbr
        AND fvh.strvoutype = 'PV'
        AND fvc.npmtreftype = 20
        AND fvc.lpmtdtlseq IS NULL
        AND cop.nclaimtype <> 58
        AND fvh.strrefnbr IN (SELECT strrefnbr
                 FROM com_trans_int_hdr
                 WHERE lmoduleintmseqnbr IN (SELECT lmoduleintmseqnbr
                            FROM com_module_intm
                            WHERE nintmtype = 4
                              AND nintmto = 8)
                   AND nvl(nisvoupassed, 0) = 1
                   AND nvl(nvouind, 0) = 2)
      GROUP BY fvh.strbasedocnbr, fvc.strcashbankcd, cpm.strclientcd, 
               cop.strpayeename, cop.straddrline1, cop.straddrline2, 
               cop.straddrline3, cop.strcountrycd, cop.strpostalcd, cop.strtown, 
               cop.strstatecd, cop.strbankbranchcd, cop.strbankacctnbr, 
               cop.nclaimtype, fvc.strvoutype, fvc.strvouseries, fvc.strbrandcd, 
               fvc.nfiscalyear, fvh.lvounbr)
 UNION ALL
 SELECT cgm.strclientcd, ccm.strfirstname, cca.straddrline1, cca.straddrline2, 
        cca.straddrline3, cca.strcountrycd, cca.strstatecd, cca.strtown, 
        cca.strpostalcd, fvh.strbasedocnbr, fvc.strcashbankcd, 
        fcm.strbankbranchcd, fcm.strbankacctnbr, fvc.strbrandcd, fvc.strvoutype, 
        fvc.strvouseries, fvh.lvounbr, fvc.nfiscalyear, 0, sum(nvl(fvh.dvouamnt, 
        0))
     FROM fin_vou_hdr fvh, fin_vou_cshbnk fvc, com_client_m ccm, 
          com_client_address cca, fin_vou_pmt_dtl fcm, com_account_m cam, 
          com_group_m cgm
     WHERE fvh.strvoutype = fvc.strvoutype
       AND fvh.strvouseries = fvc.strvouseries
       AND fvh.lvounbr = fvc.lvounbr
       AND fvh.nfiscalyear = fvc.nfiscalyear
       AND fvh.strbrandcd = fvc.strbrandcd
       AND ccm.strclientcd = cca.strclientcd
       AND cgm.strgroupid = cam.strgroupid
       AND cgm.strclientcd = ccm.strclientcd
       AND fvh.strbasedocnbr = cam.stracctid
       AND fvh.strvoutype = fcm.strvoutype
       AND fvh.strvouseries = fcm.strvouseries
       AND fvh.strbrandcd = fcm.strbrandcd
       AND fvh.nfiscalyear = fcm.nfiscalyear
       AND fvh.lvounbr = fcm.lvounbr
       AND cca.nisprimeaddr = 1
       AND fvh.strvoutype = 'PV'
       AND fvc.lpmtdtlseq IS NULL
       AND fvc.npmtreftype = 20
       AND fvh.strrefnbr IN (SELECT strrefnbr
                FROM com_trans_int_hdr
                WHERE lmoduleintmseqnbr IN (SELECT lmoduleintmseqnbr
                           FROM com_module_intm
                           WHERE nintmtype = 4
                             AND nintmto = 8)
                  AND nvl(nisvoupassed, 0) = 1
                  AND nvl(nvouind, 0) = 2)
     GROUP BY fvh.strbasedocnbr, fvc.strcashbankcd, cgm.strclientcd, 
              ccm.strfirstname, cca.straddrline1, cca.straddrline2, 
              cca.straddrline3, cca.strcountrycd, cca.strpostalcd, cca.strtown, 
              cca.strstatecd, fcm.strbankbranchcd, fcm.strbankacctnbr, 
              fvc.strvoutype, fvc.strvouseries, fvc.strbrandcd, fvc.nfiscalyear, 
              fvh.lvounbr
 ORDER BY strbasedocnbr)

Optimizer Mode Used:

  COST ALL ROWS (optimizer: CHOOSE)

Total Cost:

  1,008,374

Execution Steps:

Step #Step Name
75INSERT STATEMENT
74UNION-ALL
49SORT [UNIQUE]
48UNION-ALL
27SORT [GROUP BY]
26FILTER
24HSASYS.COM_CLIENT_ADDRESS TABLE ACCESS [BY INDEX ROWID]
23NESTED LOOPS
21NESTED LOOPS
18NESTED LOOPS
15NESTED LOOPS
12NESTED LOOPS
9HASH JOIN
7. VIEW
6SORT [UNIQUE]
5HSASYS.COM_TRANS_INT_HDR TABLE ACCESS [BY INDEX ROWID]
4NESTED LOOPS
2HSASYS.COM_MODULE_INTM TABLE ACCESS [BY INDEX ROWID]
1HSASYS.IND_MDL_INT INDEX [RANGE SCAN]
3HSASYS.IND_CTIH_VOUPASS_IND INDEX [RANGE SCAN]
8HSASYS.FIN_VOU_HDR TABLE ACCESS [FULL]
11HSASYS.FIN_VOU_PMT_DTL TABLE ACCESS [BY INDEX ROWID]
10HSASYS.XPKFIN_VOU_PMT_DTL INDEX [UNIQUE SCAN]
14HSASYS.FIN_VOU_CSHBNK TABLE ACCESS [BY INDEX ROWID]
13HSASYS.XPKFIN_VOU_CSHBNK INDEX [RANGE SCAN]
17HSASYS.COM_POLICY_M TABLE ACCESS [BY INDEX ROWID]
16HSASYS.XPKCOM_POLICY_M INDEX [UNIQUE SCAN]
20HSASYS.COM_CLIENT_M TABLE ACCESS [BY INDEX ROWID]
19HSASYS.XPKCOM_CLIENT_M INDEX [UNIQUE SCAN]
22HSASYS.COM_CLTADDR_CLTPRIME INDEX [RANGE SCAN]
25HSASYS.XPKCLM_OVERRIDE_PYMNTS INDEX [FULL SCAN]
47SORT [GROUP BY]
46NESTED LOOPS
43NESTED LOOPS
40NESTED LOOPS
38HASH JOIN
36HASH JOIN
34. VIEW
33SORT [UNIQUE]
32HSASYS.COM_TRANS_INT_HDR TABLE ACCESS [BY INDEX ROWID]
31NESTED LOOPS
29HSASYS.COM_MODULE_INTM TABLE ACCESS [BY INDEX ROWID]
28HSASYS.IND_MDL_INT INDEX [RANGE SCAN]
30HSASYS.IND_CTIH_VOUPASS_IND INDEX [RANGE SCAN]
35HSASYS.FIN_VOU_HDR TABLE ACCESS [FULL]
37HSASYS.CLM_OVERRIDE_PYMNTS TABLE ACCESS [FULL]
39HSASYS.XPKFIN_VOU_PMT_DTL INDEX [UNIQUE SCAN]
42HSASYS.FIN_VOU_CSHBNK TABLE ACCESS [BY INDEX ROWID]
41HSASYS.XPKFIN_VOU_CSHBNK INDEX [RANGE SCAN]
45HSASYS.COM_POLICY_M TABLE ACCESS [BY INDEX ROWID]
44HSASYS.XPKCOM_POLICY_M INDEX [UNIQUE SCAN]
73SORT [GROUP BY]
72HSASYS.FIN_VOU_CSHBNK TABLE ACCESS [BY INDEX ROWID]
71NESTED LOOPS
69NESTED LOOPS
66HASH JOIN [SEMI]
59HSASYS.FIN_VOU_HDR TABLE ACCESS [BY INDEX ROWID]
58NESTED LOOPS
56HASH JOIN
50HSASYS.PK_GROUP_ACCOUNT_M INDEX [FAST FULL SCAN]
55HASH JOIN
51HSASYS.INDX_COM_GROUP_M INDEX [FAST FULL SCAN]
54HASH JOIN
52HSASYS.COM_CLIENT_ADDRESS TABLE ACCESS [FULL]
53HSASYS.COM_CLIENT_M TABLE ACCESS [FULL]
57HSASYS.INDX_FVHDR_NBASEDOCTY_NBR INDEX [RANGE SCAN]
65. VIEW
64HSASYS.COM_TRANS_INT_HDR TABLE ACCESS [BY INDEX ROWID]
63NESTED LOOPS
61HSASYS.COM_MODULE_INTM TABLE ACCESS [BY INDEX ROWID]
60HSASYS.IND_MDL_INT INDEX [RANGE SCAN]
62HSASYS.IND_CTIH_VOUPASS_IND INDEX [RANGE SCAN]
68HSASYS.FIN_VOU_PMT_DTL TABLE ACCESS [BY INDEX ROWID]
67HSASYS.XPKFIN_VOU_PMT_DTL INDEX [UNIQUE SCAN]
70HSASYS.XPKFIN_VOU_CSHBNK INDEX [RANGE SCAN]

Step #DescriptionEst. CostEst. Rows ReturnedEst. KBytes Returned
  1   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index IND_MDL_INT.593,890--
  2   This plan step retrieves rows from table COM_MODULE_INTM through ROWID(s) returned by an index.1253,89049.385
  3   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index IND_CTIH_VOUPASS_IND.31--
  4   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.9,4803,890155.752
  5   This plan step retrieves rows from table COM_TRANS_INT_HDR through ROWID(s) returned by an index.310.027
  6   This plan step accepts a row set (its only child) and sorts it in order to identify and eliminate duplicates.--3,890155.752
  7   This plan step represents the execution plan for the subquery defined by the view .9,4803,89056.982
  8   This plan step retrieves all rows from table FIN_VOU_HDR.340,336786,23534,551.343
  9   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.349,840834.863
  10   This plan step retrieves a single ROWID from the B*-tree index XPKFIN_VOU_PMT_DTL.21--
  11   This plan step retrieves rows from table FIN_VOU_PMT_DTL through ROWID(s) returned by an index.210.034
  12   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.349,973292.69
  13   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index XPKFIN_VOU_CSHBNK.41--
  14   This plan step retrieves rows from table FIN_VOU_CSHBNK through ROWID(s) returned by an index.410.031
  15   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.350,06610.124
  16   This plan step retrieves a single ROWID from the B*-tree index XPKCOM_POLICY_M.21--
  17   This plan step retrieves rows from table COM_POLICY_M through ROWID(s) returned by an index.210.018
  18   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.350,06810.142
  19   This plan step retrieves a single ROWID from the B*-tree index XPKCOM_CLIENT_M.21--
  20   This plan step retrieves rows from table COM_CLIENT_M through ROWID(s) returned by an index.210.012
  21   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.350,07010.153
  22   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index COM_CLTADDR_CLTPRIME.31--
  23   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.350,07210.219
  24   This plan step retrieves rows from table COM_CLIENT_ADDRESS through ROWID(s) returned by an index.310.065
  25   This plan step retrieves all ROWIDs from the B*-tree index XPKCLM_OVERRIDE_PYMNTS by walking the index starting with its smallest key.2092,30833.809
  26   This plan step accepts multiple sets of rows. Rows from the first set are eliminated using the data found in the second through n sets.
  27   This plan step accepts a set of rows from its child node, and sorts them into groups based on the columns specified in the query's GROUP BY clause.350,07310.219
  28   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index IND_MDL_INT.593,890--
  29   This plan step retrieves rows from table COM_MODULE_INTM through ROWID(s) returned by an index.1253,89049.385
  30   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index IND_CTIH_VOUPASS_IND.31--
  31   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.9,4803,890155.752
  32   This plan step retrieves rows from table COM_TRANS_INT_HDR through ROWID(s) returned by an index.310.027
  33   This plan step accepts a row set (its only child) and sorts it in order to identify and eliminate duplicates.--3,890155.752
  34   This plan step represents the execution plan for the subquery defined by the view .9,4803,89056.982
  35   This plan step retrieves all rows from table FIN_VOU_HDR.341,96015,724,706691,027.119
  36   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.351,8701,66997.793
  37   This plan step retrieves all rows from table CLM_OVERRIDE_PYMNTS.19544,7544,589.033
  38   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.352,06720.322
  39   This plan step retrieves a single ROWID from the B*-tree index XPKFIN_VOU_PMT_DTL.210.021
  40   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.352,06910.182
  41   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index XPKFIN_VOU_CSHBNK.41--
  42   This plan step retrieves rows from table FIN_VOU_CSHBNK through ROWID(s) returned by an index.410.031
  43   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.352,07210.213
  44   This plan step retrieves a single ROWID from the B*-tree index XPKCOM_POLICY_M.21--
  45   This plan step retrieves rows from table COM_POLICY_M through ROWID(s) returned by an index.210.018
  46   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.352,07310.23
  47   This plan step accepts a set of rows from its child node, and sorts them into groups based on the columns specified in the query's GROUP BY clause.352,07410.23
  48   This plan step accepts multiple sets of rows, and combines them into one set including all duplicates.
  49   This plan step accepts a row set (its only child) and sorts it in order to identify and eliminate duplicates.1,008,37430.685
  50   This plan step retrieves all of the ROWIDs of B*-tree index PK_GROUP_ACCOUNT_M by sequentially scanning the leaf nodes.1519,562324.76
  51   This plan step retrieves all of the ROWIDs of B*-tree index INDX_COM_GROUP_M by sequentially scanning the leaf nodes.4964,6131,135.775
  52   This plan step retrieves all rows from table COM_CLIENT_ADDRESS.12,9161,196,53778,289.042
  53   This plan step retrieves all rows from table COM_CLIENT_M.18,4934,825,48756,548.676
  54   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.36,6821,196,53792,310.96
  55   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.39,41316,0221,517.709
  56   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy a condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.39,4304,851540.053
  57   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index INDX_FVHDR_NBASEDOCTY_NBR.479--
  58   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.296,15197,06615,071.771
  59   This plan step retrieves rows from table FIN_VOU_HDR through ROWID(s) returned by an index.53200.879
  60   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index IND_MDL_INT.593,890--
  61   This plan step retrieves rows from table COM_MODULE_INTM through ROWID(s) returned by an index.1253,89049.385
  62   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index IND_CTIH_VOUPASS_IND.31--
  63   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.9,4803,890155.752
  64   This plan step retrieves rows from table COM_TRANS_INT_HDR through ROWID(s) returned by an index.310.027
  65   This plan step represents the execution plan for the subquery defined by the view .9,4803,89056.982
  66   This plan step accepts two sets of rows, each from a different table. A hash table is built using the rows returned by the first child. Each row returned by the second child is then used to probe the hash table to find row pairs which satisfy an EXISTS subquery condition specified in the query's WHERE clause. Note: The Oracle cost-based optimizer will build the hash table using what it thinks is the smaller of the two tables. It uses the statistics to determine which is smaller, so out of date statistics could cause the optimizer to make the wrong choice.306,030101.699
  67   This plan step retrieves a single ROWID from the B*-tree index XPKFIN_VOU_PMT_DTL.21--
  68   This plan step retrieves rows from table FIN_VOU_PMT_DTL through ROWID(s) returned by an index.210.034
  69   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.306,04640.816
  70   This plan step retrieves one or more ROWIDs in ascending order by scanning the B*-tree index XPKFIN_VOU_CSHBNK.41--
  71   This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.306,05910.235
  72   This plan step retrieves rows from table FIN_VOU_CSHBNK through ROWID(s) returned by an index.410.031
  73   This plan step accepts a set of rows from its child node, and sorts them into groups based on the columns specified in the query's GROUP BY clause.306,06010.235
  74   This plan step accepts multiple sets of rows, and combines them into one set including all duplicates.
  75   This plan step designates this statement as an INSERT statement.1,008,374----