I'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.