All three tables have the same integer key,
and it's indexed.
I parenthesized the joins to do the two
small tables first.
I'm running and INSERT INTO ... SELECT
query with this join (one record added per record in join), 4 hours down and all
I have to show for it is 100 recycled transaction logs. ?
If it ever returns, I can post the Explain
output.
|
- Re: [PERFORM] JOIN order, 15K, 15K, 7MM rows Andrew Lazarus