John.H wrote:
I found that when I use a query as a subquery it will not use the right index at all??
Post the query, the explain and the relevant table details and someone might have a suggestion.
Also - not every single query is going to be able to use an index, this may be one of those cases.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]