MySQL Forums
Forum List  »  Performance

Re: UNION Query is slow
Posted by: Rick James
Date: January 31, 2009 01:48AM

Do you have INDEX (cif, date) ?

I have one UI that regularly creates a UNION of 50 selects; it runs tolerably fast.

How many rows in the result set? Does it have LIMIT on the end? If so, how many rows _before_ the LIMIT is applied?

Options: ReplyQuote


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