[OliverJones]

Good material!

It has to be said, the order of columns in correctly designed multicolumn BTREE indexes is governed by the shape of the queries the indexes support.

So don't arbitarily reorder columns in your indexes to handle alignment.