4 ms·
Am I missing something fundamental like a WHERE clause? I see a join, but no limiting of rows beyond that.
by protomyth 8y ago
Am I missing something fundamental like a WHERE clause? I see a join, but no limiting of rows beyond that.
- Sean1708 8y agoI think they just wanted all of the data.
- protomyth 8y agoIs there an actual schema and does MariaDB do index scans?
- nartz 8y agoYou're right - this query doesnt make sense, because if he's left joining, he should at least do where tableB.someCol != null or something. Otherwise, the join is useless (or he should use an inner join)