On 04/05/2010 02:06 PM, chen jia wrote: > Hi there, > > I run simple statement like this: > > create table c > select * from a > union > select * from b; > > where table a has 90,402,534 rows, and table b has 33,358,725 rows. > Both tables have the same three variables. > > It's taken a long time, more than half an hour now. How do I make it faster?
UNION ALL, perhaps? -r -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org