We know that the views sort data in ascending order. Since N1QL uses views behind the scenes, we assume that ORDER BY in asc is performant. How does N1QL handle ORDER BY desc? Is there a difference in performance?
For example in SQL relational database when an index is created, one can specify the order (asc / desc). Is there something similar in N1QL? In particular for paging results, does it stop searching once it reaches the LIMIT or does it have to go through the whole index prior to sorting both for asc and desc.
It would also be helpful to know the type / name of the indexing algorithm that is being used.