4 ms·

To me, this just seems to be struct packing[1] on the database layer. I would find the opposite behavior of automatic reordering of columns strange. [1] http:/

• vertex-four 9y ago
  As a counter-argument: databases do ~interesting~ things with your queries and the layout of your data anyway. SQL is meant to be declarative - it's not meant to define exactly how an operation is done, only that it's done in a method that results in something that logically looks like what you've declared it to look like. So as long as the row is ordered correctly when you do a `SELECT *`, it'd be perfectly reasonable in my opinion to store it physically in any order the database engine prefers.