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.

Continue reading Index on (a,b) vs. (b,a)?