Hi Brice,
On Jan 2, 2014, at 2:24 PM, Brice André wrote:
Yes, except that on b, it's a inequality operator.
Moving your reply to the list.
Assuming the data type you are using supports B-tree indexes, I can't think of any cases where inequality (specifically <> or !=) would use an index, so a single index on 'a' is what you are looking for.
However, if you are doing anything with equality (<, <=, =, >=, >) then you would wnat a multi-column index on (a,b), in that column order.
Best,
Jonathan