On Thu, Jul 19, 2012 at 3:10 AM, Another Sillyname <anothersname at googlemail.com> wrote: .... > Thanks for this but didn't help I'm afraid. It might be interesting to take the select, and run it under an EXPLAIN (perhaps an extended explain) to see what might be the cause of (what sounds like) a table scan.