Re: Speed Up Query

> > AND Substring(a.mob, 1, 4) = b.mob_series > There's what is probably the major problem with your query: your join condition. Indices (you *do* have them on your join fields, don't you ?) only work on the entire field you've indexed. Function indices are not supported in MySQL, so you'll

Re: Speed Up Query

using Execution plan: ++++-+---++-+---+-+- ---+ | id | select_type| table | type| possible_keys | key| key