Re: Re-Reason of Slowness of Query

I just want to retrieve that id 's from page_content which do not have
any entry in clause2 table.

Thanks , Adarsh

Vitalii Tymchyshyn wrote:
> 23.03.11 11:17, Adarsh Sharma ???????(??):
>>
>> I think it is very much faster but I don't understand the query :
>>
>> *explain select distinct(b) from t1,t2 where t1.b >t2.d union all
>> select distinct(b) from t1,t2 where t1.b <t2.d;
>> *
> I don't understand it too. What are you trying to get? Is it
> select distinct(b) from t1 where b > (select min(d) from t2)* *or b
> < (select max(d) from t2)
> ?
>
> Can you explain in words, not SQL, what do you expect do retrieve?
>
> Best regards, Vitalii Tymchyshyn