SQL - Mejorar performance query - Oracle 12 - Linux

select  /*+ parallel(ASSET_MP,16)*/  distinct FF.ID_MAYORISTA,

        FF.NUMERO_PROFORMA,

		FF.PERIODO,

		FF.FECHA_RECARGA,

		FF.ID_RECARGA,

		FF.NRO_LINEA,

		FF.MONTO_RECARGA,

		FF.CONSUMO_DATOS,

		FF.CONSUMO_VOZ,

		FF.NOMBRE_ARCHIVO,

         A.MSISDN__C ,

		 A.VLOCITY_CMT__BILLINGACCOUNTID_,

         B.ID, B.BILLINGSTATECODE,

		 B.CUSTOMERINTEGRATIONID__C,

		 B.ACCOUNTINTEGRATIONID__C,

		 B.BILLING_ADDRESS__C,

         C.ID,

		 C.LOCATION_ID__C,

		 C.PROVINCE__C,

         D.ID,

		 D.MUNICIPALITY__C,

		 D.STATENAME__C

from A001540.FF_ENTIDAD_MERCADOPAGO_AUX FF

left join A001540.ASSET_MP A on FF.nro_linea = A.MSISDN__C

left join A001540.ACCOUNT B on A.VLOCITY_CMT__BILLINGACCOUNTID_ = B.id

left join A001540.ADDRESS2__C C on B.BILLING_ADDRESS__C = C.id

left join A001540.LOCATION__C D on C.LOCATION_ID__C = D.id

where FF.ASSET_BILLINGACC is null;

ROWS count on FF_ENTIDAD_MERCADOPAGO_AUX

  COUNT(1)

----------

   3010478

ROWS count on ASSET_MP;

  COUNT(1)

----------

  21502266

ROWS count on ACCOUNT;

  COUNT(1)

----------

  65028597

Rows count on A001540.ADDRESS2__C;

  COUNT(1)

----------

  39866344

Rows count on  A001540.LOCATION__C;

  COUNT(1)

----------

      8835