List:General Discussion« Previous MessageNext Message »
From:chen jia Date:April 5 2010 6:06pm
Subject:Slow Union Statement
View as plain text  
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?

Best,
Jia
Thread
Slow Union Statementchen jia5 Apr
  • Re: Slow Union StatementRudy Lippan5 Apr
  • RE: Slow Union StatementGavin Towey5 Apr
    • Re: Slow Union Statementchen jia5 Apr