Hacker News new | ask | show | jobs
by OliverJones 618 days ago
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.