UNION Query is slow
Hi!,
I am using a query where i took union of many tables though it is not much slow still I think it's performance can be improved. Can any one please help me in doing so. I just wanted to know, can I add some thing in where clause to accomplish that. I can't use UNION ALL as this query is generated by an API. Currently in where clause i m using on equal condition and one date condition like...
where cif = 'XXXXXXXX' and date < 'yyyy-mm-dd-hh.mm.ss.000000'
Thanks in advance...
Subject
Views
Written By
Posted
UNION Query is slow
6565
January 30, 2009 11:08AM
2171
January 31, 2009 01:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.