I was reading an article the other day on sub-queries within MySQL having quite large performance issues.

After doing a bit of searching on Google most of the articles/posts I find are around 2005 and I was wondering if the issues are still present in more recent builds/releases?

From my understanding MySQL doesn't use the index within sub-queries creating full table scan situations.

Any information would be greatly appreciated.

    i believe joins are always faster than sub-queries, mostsub-queries can be converted in to joins.

      Write a Reply...