>Thanks for your inputs Eric.
>I tried this but it couldn't give me any insight abt
>how can optimize this
>for space saving of temp tables.
>Maybe I am not expert enough to interpret this
output, >so here it is -
>- Manish
Seeing the explain log, it looks to me like you donot
have any index def
>Thanks for your inputs Eric.
>I tried this but it couldn't give me any insight abt
>how can optimize this
>for space saving of temp tables.
>Maybe I am not expert enough to interpret this
output, >so here it is -
>- Manish
Seeing the explain log, it looks to me like you donot
have any index def
(0.00 sec)
Any inputs???
TIA,
- Manish
- Original Message -
Sent: Saturday, December 04, 2004 10:26 AM
Subject: Re: Help me optimize this query
> If you change the update to a select you can use explain to see it's
> execution path just like you would with a normal sel
If you change the update to a select you can use explain to see it's
execution path just like you would with a normal select. The rows
returned are the rows that would be matched by the update query.
Example:
explain select * from t1, t2 where t1.YYY=t2. and t2. like '%X%';
Optimize the q
I am trying to execute this query and it is failing with Table is full error
(I know I can make temp tables big).
update t1, t2
set t1.XXX=1
where t1.YYY=t2. and t2. like '%X%';
My t1 has 10,00,000+ records and t2 has about 70,000 recorsds. I would like
to know how can I optimize this quer