It would be better if the database were architected slightly different, but that's not an option at the present time.
The following query is similar to one I posted several days ago. I am wondering if anyone can offer any assistance on how to improve it's performance. Here is the query: http://pastie.org/2347990 Here is the EXPLAIN statement: http://pastie.org/2347981 I think that I have indexes in all the right places, but I'm not as experienced with UNIONS. Anything I can do to speed this up? It's taking 5 seconds to run. wade _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
