[GENERAL] 26h Query.

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

Re: [GENERAL] 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),