MySQL Forums
Forum List  »  Performance

UNION Query is slow
Posted by: rajnish mohan
Date: January 30, 2009 11:08AM

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...

Options: ReplyQuote


Subject
Views
Written By
Posted
UNION Query is slow
6438
January 30, 2009 11:08AM
2150
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.