MySQL Forums
Forum List  »  General

Re: Sub Query is Very Slow
Posted by: Asad ahmed
Date: December 05, 2011 03:15AM

The first part (i.e)

drop table if exists tmp;
create table tmp
select cont from temp_tag
where heading is null or heading='' or publishdate<>'2011-10-20' or type<>'story' or cont=0;

is not taking much time but the second query

select o.articlenumber
from temp_tag o left join tmp on o.articlenumber=tmp.cont
where tmp.cont is null;

is taking to much time to execute.

Options: ReplyQuote

Written By
December 02, 2011 11:33PM
December 03, 2011 01:38PM
December 04, 2011 10:52PM
December 05, 2011 02:30AM
Re: Sub Query is Very Slow
December 05, 2011 03:15AM
December 05, 2011 11:44PM
December 05, 2011 11:48PM
December 06, 2011 02:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.