Re: [SQL] Joining two large tables on a tiny subset of rows

2005-07-27 Thread Richard Huxton
Dmitri Bichko wrote: Hello, I have two tables, one has a foreing key from the other (only showing the relevant columns and indices here): Table "expresso.probes" Column| Type | Modifiers -++--- platform_id | inte

Re: [SQL] Joining two large tables on a tiny subset of rows

2005-07-26 Thread Gnanavel S
On 7/27/05, Dmitri Bichko <[EMAIL PROTECTED]> wrote: Hello,I have two tables, one has a foreing key from the other (only showingthe relevant columns and indices here): Table "expresso.probes"   Column|  Type  | Modifiers-++

[SQL] Joining two large tables on a tiny subset of rows

2005-07-26 Thread Dmitri Bichko
Hello, I have two tables, one has a foreing key from the other (only showing the relevant columns and indices here): Table "expresso.probes" Column| Type | Modifiers -++--- platform_id | integer| no