Re: INDEX suggestion needed

--- Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> wrote:
> My typical queries are like that:
> SELECT count(a_id) AS count
>   FROM (
>     SELECT DISTINCT a_id FROM stat_pages
>       WHERE m_id = '35'
>         AND visit >= '2002-09-01'
>         AND visit <= '2002-09-30'
>   ) AS foo;
>

You can do SELECT count(DISTINCT a_id) FROM ...

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com