> 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
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 intensive) to just use:
"FROM zipwork1 as z, pctwork1 as p WHERE z.run_id = p.run_id"
to join the tables if they are 1-1 related.
Andrew Murphy
-Original
