OPERACION OBJETO COST CARDINALITY BYTES ------------------------------------------------------------ ------------------------------ ---------- ----------- ---------- SELECT STATEMENT () 5136304 2500215 1397620185 HASH (UNIQUE) 5136304 2500215 1397620185 HASH JOIN (RIGHT OUTER) 4841173 2500215 1397620185 TABLE ACCESS (FULL) LOCATION__C 3471 8835 644955 HASH JOIN (OUTER) 4837696 2500215 1215104490 NESTED LOOPS (OUTER) 4837696 2500215 1215104490 STATISTICS COLLECTOR () HASH JOIN (OUTER) 3879671 2500215 1037589225 NESTED LOOPS (OUTER) 3879671 2500215 1037589225 STATISTICS COLLECTOR () HASH JOIN (OUTER) 209544 2500215 827571165 NESTED LOOPS (OUTER) 209544 2500215 827571165 STATISTICS COLLECTOR () TABLE ACCESS (FULL) FF_ENTIDAD_MERCADOPAGO_AUX 34586 2485414 676032608 TABLE ACCESS (BY INDEX ROWID BATCHED) ASSET_MP 69310 1 59 INDEX (RANGE SCAN) IDX_MP_MSISDN TABLE ACCESS (FULL) ASSET_MP 69310 21502266 1268633694 TABLE ACCESS (BY INDEX ROWID BATCHED) ACCOUNT 3341481 1 84 INDEX (RANGE SCAN) X1711291402735ACCOUNT_ID TABLE ACCESS (FULL) ACCOUNT 3341481 63417901 5327103684 TABLE ACCESS (BY INDEX ROWID BATCHED) ADDRESS2__C 752212 1 71 INDEX (RANGE SCAN) X1803260024060ADDRESS2__C_ID TABLE ACCESS (FULL) ADDRESS2__C 752212 39542420 2807511820 23 rows selected. INDEX_NAME TABLE_NAME LAST_ANALYZED ----------------------------------- ----------------------------------- ------------------- IDX_ACCOUNT_CREATEDDATE ACCOUNT 05/08/2023 20:33:32 SYS_IL0000075426C00171$$ ACCOUNT SYS_IL0000075426C00191$$ ACCOUNT SYS_IL0000075426C00190$$ ACCOUNT SYS_IL0000075426C00189$$ ACCOUNT SYS_IL0000075426C00188$$ ACCOUNT SYS_IL0000075426C00187$$ ACCOUNT SYS_IL0000075426C00186$$ ACCOUNT SYS_IL0000075426C00185$$ ACCOUNT SYS_IL0000075426C00184$$ ACCOUNT SYS_IL0000075426C00183$$ ACCOUNT SYS_IL0000075426C00182$$ ACCOUNT SYS_IL0000075426C00181$$ ACCOUNT SYS_IL0000075426C00180$$ ACCOUNT SYS_IL0000075426C00179$$ ACCOUNT SYS_IL0000075426C00240$$ ACCOUNT X1711291402735ACCOUNT_ID ACCOUNT 05/08/2023 20:33:57 SYSTEMMODSTAMP_636 ACCOUNT 05/08/2023 20:34:15 ACCOUNT_ACCOUNTINTID__C ACCOUNT 05/08/2023 20:33:24 ACCOUNT_LMOD ACCOUNT 05/08/2023 20:33:46 SYS_IL0000075426C00192$$ ACCOUNT SYS_IL0000075426C00172$$ ACCOUNT SYS_IL0000075426C00173$$ ACCOUNT SYS_IL0000075426C00174$$ ACCOUNT SYS_IL0000075426C00175$$ ACCOUNT SYS_IL0000075426C00176$$ ACCOUNT SYS_IL0000075426C00177$$ ACCOUNT SYS_IL0000075426C00178$$ ACCOUNT ADDRESS2__C_PROVINCE__C ADDRESS2__C 13/08/2023 16:54:43 ADDRESS2__C_LMOD ADDRESS2__C 13/08/2023 16:54:28 ADDRESS2__C_LOCATION_NAME ADDRESS2__C 13/08/2023 16:54:51 SYSTEMMODSTAMP_789 ADDRESS2__C 13/08/2023 16:54:36 X1803260024060ADDRESS2__C_ID ADDRESS2__C 13/08/2023 16:54:17 ADDRESS2__C_ACCOUNT_OWNER__C ADDRESS2__C 13/08/2023 16:54:07 IDX_MP_MSISDN ASSET_MP 26/09/2023 22:01:33 IDX_RECARGA FF_ENTIDAD_MERCADOPAGO_AUX 28/09/2023 15:01:44 IDX_BILLADDR FF_ENTIDAD_MERCADOPAGO_AUX 28/09/2023 15:01:44 IDX_LINEA FF_ENTIDAD_MERCADOPAGO_AUX 28/09/2023 15:01:44 IDX_BILLINGACC FF_ENTIDAD_MERCADOPAGO_AUX 28/09/2023 15:01:44 LOCATION__C_LMOD LOCATION__C 28/09/2023 15:03:48 SYSTEMMODSTAMP_74 LOCATION__C 28/09/2023 15:03:48 X1711291450128LOCATION__C_ID LOCATION__C 28/09/2023 15:03:48