[SQL] Multiple DB join

2006-08-14 Thread Sumeet Ambre
Hi All, I have a database which consists of 20 million records and I've split up the db into 6-7 dbs. I have a base database which consists of the ids with link all the databases. I'm performing search on this single base table. After searching i get some ids which are ids in the other database

Re: [SQL] Multiple DB join

2006-08-15 Thread Sumeet Ambre
Andrew Sullivan wrote: On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote: Hi All, I have a database which consists of 20 million records and I've split up the db into 6-7 dbs. You can do this (as someone suggested with dblink), but I'm wondering why the