5 ms·
Is #1 actually correct? The plain interpretation would be that if you join two tables on one field, it can only read the index from one table at a time and nee
by ajross 18y ago
Is #1 actually correct? The plain interpretation would be that if you join two tables on one field, it can only read the index from one table at a time and needs to do a linear search through the second table for each row. Clearly that's ridiculous, and not MySQL's behavior at all. Clearly this is a more subtle problem. The rest of the text implies this is a scaling issue ("wait until your tables get large enough"), but I don't see why that's the case.
Can someone enlighten me?
- ambition 18y agoI'm not sure, but perhaps he means one index per table per query.