We are migrating to 6.5 and so I’m wondering if I will be able to do something like this.
say the index is on (prop, createDate asc)
and say I want to query
select * from bucket where prop = ‘foo’
order by createDate desc
I believe for 6.1 you have to create a distinct index, which can be onerous and heavy should you want to support arbitrary ordering
does 6.5 support this?
is it ridiculous? and if not is on the roadmap?