Index was missing on ID column in MemSQL's case, so MemSQL was running entire table scan instead of using the index as MySQL.
Index was missing on ID column in MemSQL's case, so MemSQL was running entire table scan instead of using the index as MySQL.