Create multi field index

Mobile
1

Can I create a multi-field index and specify order asc/desc per segment?
Say lastName, birthdate. With lastName asc and birthdate desc.

(If not, how would I query it to get this result?)

Thanks.
nat

2

sure.

CREATE  INDEX ix1 ON default(lastName ASC, bithdate DESC);

SELECT b.*
FROM default
WHERE b.lastName > "b"
b.lastName ASC, b.birthdate DESC;

Index key ASC/DESC is mainly if query has order by and follows index order it can avoid sort

3

One moment. I posted the question in mobile - lite forum.
I think your answer applies only to server.
?

4

Oh. I did not see forum topic.

5

Are you using QueryBuilder or N1QL, and on what platform?