1 SIMPLE ppc ALL PRIMARY NULL NULL NULL 2738 1 SIMPLE pmc ALL PRIMARY NULL NULL NULL 2745 1 SIMPLE r eq-ref PRIMARY PRIMARY 4 drupal6b.n.uid 1 Using where With the performance I see, I am not suprised to see "filesort" in there.
drupal archive – http://www.pubbs.net/