Simple Join Table Scan Question (1 reply)
(MySQL.com) Hi everyone,
I had a quick question. If I do a query like so:
SELECT *
FROM
a
LEFT JOIN
b
ON
a.field = 1 AND a.id = b.a_id
If a.field is not 1, is there even a table scan for table b?
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:08:59
