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

Reply via email to