4 ms·
Around the same time, I wrote an extremely convoluted MySQL query that changed its plan based on the column order in the SELECT clause. I wouldn't post snooty
by renegade-otter 3y ago
Around the same time, I wrote an extremely convoluted MySQL query that changed its plan based on the column order in the SELECT clause.
I wouldn't post snooty and dismissive comments about this - assume that you are in a company of people who have been to more rodeos than you have.
- _a_a_a_ 3y agoI've >25 years of DB rodeoing. Perhaps I know something about this by now. See my other answers on this thread. > that changed its plan based on the column order in the SELECT clause. Hmm? Could you elaborate; you mean the order of the cols or using ORDER BY? I assume you mean the latter but it sounded like the former.