Re: [SQL] How to union table without union statement?

I think the tables should contain 50k rows of record and it should be insert 7k rows per month. And the condition of the database is running, so it should not change the tables to partitioning right now. I am looking for some JOIN statement but still doesn't understand how to use JOIN to replace

Re: [SQL] How to union table without union statement?

schema? -- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *calendarw *Sent:* Wednesday, February 28, 2007 4:33 AM *To:* pgsql-sql@postgresql.org *Subject:* [SQL] How to union table without union statement? Hi, I need to combine 10 tables which c

Re: [SQL] How to union table without union statement?

*Sent:* Wednesday, February 28, 2007 4:33 AM *To:* pgsql-sql@postgresql.org *Subject:* [SQL] How to union table without union statement? 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 "o

Re: [SQL] How to union table without union statement?

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 collectio

[SQL] How to union table without union statement?

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? Thanks.