SQL_ID 7n2g5z2967u6v
--------------------
SELECT CAPNUMCUENTA, CIFNOMBRECLIE NOMBRE_CUENTA FROM CAPCUENTAS a, CIFGENERALES b WHERE 
a.CAPCODCLIENTE = b.CIFCODCLIENTE
 
Plan hash value: 3405681290
 
---------------------------------------------------------------------------------------------------------
| Id  | Operation               | Name                  | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
---------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |                       |       |       |       |  1189 (100)|          |
|   1 |  HASH JOIN              |                       | 69254 |  3516K|  2032K|  1189   (2)| 00:00:15 |
|   2 |   VIEW                  | index$_join$_001      | 69254 |  1217K|       |   817   (1)| 00:00:10 |
|   3 |    HASH JOIN            |                       |       |       |       |            |          |
|   4 |     INDEX FAST FULL SCAN| CAPCUENTAS_IDX_3      | 69254 |  1217K|       |   195   (2)| 00:00:03 |
|   5 |     INDEX FAST FULL SCAN| CAPCUENTAS_IDX_6      | 69254 |  1217K|       |   415   (1)| 00:00:05 |
|   6 |   INDEX FAST FULL SCAN  | IDXCIFGENERALESNOMCOD | 75924 |  2520K|       |   103   (1)| 00:00:02 |
---------------------------------------------------------------------------------------------------------
 
SQL_ID 7n2g5z2967u6v
--------------------
SELECT CAPNUMCUENTA, CIFNOMBRECLIE NOMBRE_CUENTA FROM CAPCUENTAS a, CIFGENERALES b WHERE a.CAPCODCLIENTE = b.CIFCODCLIENTE
 
Plan hash value: 3454075448
 
---------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                      | Name                  | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |    TQ  |IN-OUT| PQ Distrib |
---------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |                       |       |       |       |   941 (100)|          |        |      |            |
|   1 |  PX COORDINATOR                |                       |       |       |       |            |          |        |      |            |
|   2 |   PX SEND QC (RANDOM)          | :TQ10004              | 66129 |  3358K|       |   941   (2)| 00:00:12 |  Q1,04 | P->S | QC (RAND)  |
|   3 |    HASH JOIN                   |                       | 66129 |  3358K|  1944K|   941   (2)| 00:00:12 |  Q1,04 | PCWP |            |
|   4 |     PX RECEIVE                 |                       | 66107 |  1162K|       |   577   (3)| 00:00:07 |  Q1,04 | PCWP |            |
|   5 |      PX SEND HASH              | :TQ10003              | 66107 |  1162K|       |   577   (3)| 00:00:07 |  Q1,03 | P->P | HASH       |
|   6 |       VIEW                     | index$_join$_001      | 66107 |  1162K|       |   577   (3)| 00:00:07 |  Q1,03 | PCWP |            |
|   7 |        HASH JOIN BUFFERED      |                       |       |       |       |            |          |  Q1,03 | PCWP |            |
|   8 |         PX RECEIVE             |                       | 66107 |  1162K|       |   186   (2)| 00:00:03 |  Q1,03 | PCWP |            |
|   9 |          PX SEND HASH          | :TQ10001              | 66107 |  1162K|       |   186   (2)| 00:00:03 |  Q1,01 | P->P | HASH       |
|  10 |           PX BLOCK ITERATOR    |                       | 66107 |  1162K|       |   186   (2)| 00:00:03 |  Q1,01 | PCWC |            |
|  11 |            INDEX FAST FULL SCAN| CAPCUENTAS_IDX_3      | 66107 |  1162K|       |   186   (2)| 00:00:03 |  Q1,01 | PCWP |            |
|  12 |         PX RECEIVE             |                       | 66107 |  1162K|       |   384   (1)| 00:00:05 |  Q1,03 | PCWP |            |
|  13 |          PX SEND HASH          | :TQ10002              | 66107 |  1162K|       |   384   (1)| 00:00:05 |  Q1,02 | P->P | HASH       |
|  14 |           PX BLOCK ITERATOR    |                       | 66107 |  1162K|       |   384   (1)| 00:00:05 |  Q1,02 | PCWC |            |
|  15 |            INDEX FAST FULL SCAN| CAPCUENTAS_IDX_6      | 66107 |  1162K|       |   384   (1)| 00:00:05 |  Q1,02 | PCWP |            |
|  16 |     BUFFER SORT                |                       |       |       |       |            |          |  Q1,04 | PCWC |            |
|  17 |      PX RECEIVE                |                       | 74140 |  2461K|       |   103   (1)| 00:00:02 |  Q1,04 | PCWP |            |
|  18 |       PX SEND HASH             | :TQ10000              | 74140 |  2461K|       |   103   (1)| 00:00:02 |        | S->P | HASH       |
|  19 |        INDEX FAST FULL SCAN    | IDXCIFGENERALESNOMCOD | 74140 |  2461K|       |   103   (1)| 00:00:02 |        |      |            |
---------------------------------------------------------------------------------------------------------------------------------------------