Don't forget that when using multicolumn indexes, order matters. The index will still be used if you filter (or sort by) any prefix of the column list, but not

Don't forget that when using multicolumn indexes, order matters. The index will still be used if you filter (or sort by) any prefix of the column list, but not otherwise.