Re: 26h Query.

On Sun, Mar 20, 2005 at 10:10:14AM -0800, Jason Leach wrote:
> hi,
>
> I'm having a bit of trouble with my SQL query. It takes about 26h to
> run on a 3Ghz PC. I'd really like to speed this up.
>
> I put this query in a loop to iterate over 20 tables (each table
> including summary has 400k records), each time the table name changes.
> I this case it's m_alal. Each table has an identical primary key
> ECP_TAG but the RATING column is different. What I doing is:

You're going to need to post the EXPLAIN ANALYZE output if you expect
any meaningful response...
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.