Index on (a,b) vs. (b,a)?
January 28th, 2013 by depesz | Tags: , , , | 7 comments »

Whenever you are considering creation of multicolumn index, there is a question what should be the order of columns in this index. I'll try to analyze various cases of this situation.