i solved the problem...
for the ones, who wants to know:
only creating an index on artikelnummer on both tables made the query
beeing ready after 2 seconds again :-)
Oliver
On Wed, 15 Sep 2004 00:38:59 +0200, Oliver Schiessl
<[EMAIL PROTECTED]> wrote:
MySQL 3.23.58:
ive got 2 tables with ca.
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:
>
>
>
> >>
> >>
> >> Why the LEFT JOINS ?
> >> They're (mostly) used for finding set membership; whenever you see
> >> 'LEFT JOIN b' without s fo
On 11-Jul-01 Mike W. Baranski wrote:
> Awsome answers! I'll clear a few things up where appropriate
>
> Don Read wrote:
>>
>>
>> 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 t
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 badge_h
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, ba
