Flex Index ORDER BY pushdown for pagination

SELECT t.*

FROM default AS t USE INDEX (USING FTS)

WHERE t.type = "order"

      AND t.product IN ["p0", "p5", "p10", "p15"]

ORDER BY t.otime

OFFSET 10

LIMIT 20;

Above one Pagination Query. 

• Flex Index able to handle ORDER, Offset, Limit (when order fields are available)
• As it is not covered it if Flex Index handles it can produce only 20 documents avoid unnecessary Fetch.

TBD:

• How far can we go?
• Example: Even predicate is not exact (offset and limit) present can we use FTS ORDER and not push limit, offset because Fetch expensive. At the same time sort size might be more?  Keshav Murthy need your input.