Re: help with long query

[Felix Geerinckx]

George Develekos wrote:

> I have a long query that involves a single table that has four attributes, let's call them A,B,C
> and T, where A/B/C are strings and T is Timestamp.
>
> The query goes like this:
>
> select count(*) from mytable where T between T1 and T2 and B=b and C=c and A in (select A
> from mytable where B=b2 and C=c2)

Can you post the result of

EXPLAIN SELECT .... \G

What indexes do you have on your table?

--
felix
Please use BBCode to format your messages in this forum.