On Wed, May 15, 2002 at 03:31:30PM -0400, Doug Fields wrote:
[Much snipped about mergejoins]
> AND LOWER(a.email) = LOWER(b.email);
There's your problem. You're not comparing the two columns, you're comparing
the two columns after running through a function, so it can't use the index.
Try creating an index on LOWER(email) instead of just email.
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America