Re: join optimization problem

How about this? It should spit out the same number, but be quite a bit
quicker at it. Untested of course...

select t.thread_id,
t.forum_id,
t.thread_title,
t.thread_owner,
t.thread_owner_id,
t.date_created,
t.thread_hits,
t.poem_reference,
t.bArchived,
count, maxdate
from fbof_thread t
LEFT OUTER JOIN
(select thread_id
, count(msg_id) as count
, max(date_created) as maxdate
from msg
group by thread_id
) as tab ON m.thread_id = t.thread_id
where t.forum_id = 1
and t.bArchived = 0
and t.bSticky = 0
order by t.date_created desc

> can anyone point out to me where I'm going wrong here? I can't seem to make
> it faster for the life of me.... I've tried adding indices on all the main
> fields etc but nada. I'm not subscribed the list currently so please reply
> to my address as well as the list.