Hello Santino, I tried to formulate my query as you suggested. According to EXPLAIN, MySQL seems to process it the same way as my first query, working first on table C and using where, temporary, and filesort.
Thanks, Mike. -----Original Message----- From: Santino [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:01 PM To: Mike Boone; [EMAIL PROTECTED] Subject: Re: Optimizing Custom Full Text Index Have You tryed: SELECT A.id, COUNT(A.id), A.category FROM A, C WHERE C.content_id=A.id AND A.status='Active' AND (C.stem_word_id IN (10,20,30)) GROUP BY A.id Santino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]