On Tue, 11 Sep 2018 at 13:56, Arup Rakshit <ar@xxxxxxx> wrote:
I have define a simple B Tree index on column *country* for users table. I don’t understand why the order by column not using the index scan when using *distinct* keyword in the select clause. Can anyone explain what is happening here?
Bear in mind that index skip scans aren't yet implemented, which (unless I've missed the point) seems to be what you're expecting to help here.
Geoff
