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.