> I don't know if this will improve performance but here is an example, use> outer join.> select C.TRC_CUENTA,nvl(A.CTS_NOMBRE,B.CTS_NOMBRE) name>> from transace C,>> ( select CTS_CUENTA,CTS_NOMBRE from cuentaE where cts_TRATAMIENTO = 'IN')
A,
>> ( select CTS_CUENTA,CTS_NOMBRE from cuentaE where cts_TRATAMIENTO = 'EG')
B
>> WHERE>> C.TRC_CUENTA = A.CTS_CUENTA(+) AND C.TRC_CUENTA =B.CTS_CUENTA(+)>>>> If you could create a materialized view from this I think this could
really
> help.

Even you could try to create a view.
>> If you see when there is records in the second query it will return null>> Juan Carlos Reyes Pacheco> OCP> Database 9.2 Standard Edition

Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.