3 ms·
"How do you feel about the reported performance of "SELECT * FROM table ORDER BY id DESC LIMIT 5;"?" Index was missing on ID column in MemSQL's case, so MemSQL
by tintor 14y ago
"How do you feel about the reported performance of "SELECT * FROM table ORDER BY id DESC LIMIT 5;"?"
Index was missing on ID column in MemSQL's case, so MemSQL was running entire table scan instead of using the index as MySQL.