> Ask it and see...
>
> EXPLAIN SELECT
>
> Jeremy
mysql> exlain why youre not writing all (non-select) queries to the binary
log when replicating databases;
ERROR 1064: You have an error in your SQL syntax near 'exlain why youre not
writing all (non-select) queries to the binary log when r
On Wed, Sep 26, 2001 at 05:16:26AM -0400, Will French wrote:
> Thanks for responding.
>
> That's interesting. I will definitely give your sugestion a try. I thought
> the two syntaxs had the same effect. What does the optimizer do
> differently?
Ask it and see...
EXPLAIN SELECT
Jerem
ber 26, 2001 5:12 AM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: Disk-bound joins
>
>
> Hi,
>
> Excuse me if this is wrong, but I think its the INNER JOIN which
> is slowing
> down the query.
>
> Wouldnt it be better (less memory intens
rew Murphy
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 7:23 am
To: [EMAIL PROTECTED]
Subject: Disk-bound joins
Hi all,
I have two very large tables (4 million recs each) where the records from
each have a 1-to-1 relationship. They share a primary key (int)
Hi all,
I have two very large tables (4 million recs each) where the records from
each have a 1-to-1 relationship. They share a primary key (int) and there
are no unmatched records in either table (i.e. it is a true 1-to-1). I am
trying to combine a few columns from each of the two tables into
