Re: How to union table without union statement?

From: Richard Huxton <dev(at)archonet(dot)com>
To: calendarw <calendarw(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to union table without union statement?
Date: 2007-02-28 11:05:40
Message-ID: 45E56204.1040202@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

calendarw wrote:
> Hi,
>
> I need to combine 10 tables which contain same table structure and join an
> "other table" to show the latest 200 record, I am join the "other table"
> first and using union statement to select all record now but the collection
> time is super slow, how can I improve the collection speed?

Start by providing the information needed to diagnose the problem.

Post the output of EXPLAIN ANALYSE <query> along with the query SQL and
any table definitions/sizes you think are useful.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-02-28 11:07:39 Re: Conditional NOT NULL constraint
Previous Message calendarw 2007-02-28 10:33:04 How to union table without union statement?