Re: Slow join... Big table

2001-07-12 Thread Mike W. Baranski
Don Read wrote: On 11-Jul-01 Mike W. Baranski wrote: Awsome answers! I'll clear a few things up where appropriate Don Read wrote: snip Why the LEFT JOINS ? They're (mostly) used for finding set membership; whenever you see 'LEFT JOIN b' without s following 'b IS [NOT]

RE: Slow join... Big table

2001-07-11 Thread Don Read
On 11-Jul-01 Mike Baranski wrote: I was wondering if anyone had any suggestions on the following problem. I have a table with about 7 million rows, and I'm using the following join:CREATE TABLE badge_history_resolved SELECT badge_history.id AS id, badge_history.xact_date AS xact_date,

Re: Slow join... Big table

2001-07-11 Thread Mike W. Baranski
Awsome answers! I'll clear a few things up where appropriate Don Read wrote: On 11-Jul-01 Mike Baranski wrote: I was wondering if anyone had any suggestions on the following problem. I have a table with about 7 million rows, and I'm using the following join:CREATE TABLE

Re: Slow join... Big table

2001-07-11 Thread Don Read
On 11-Jul-01 Mike W. Baranski wrote: Awsome answers! I'll clear a few things up where appropriate Don Read wrote: snip Why the LEFT JOINS ? They're (mostly) used for finding set membership; whenever you see 'LEFT JOIN b' without s following 'b IS [NOT] NULL' clause 'tis the