I have in my bucket a _type called batch_ino where i store summary info of every batch i run. All works fine and as expected but when i try to get the last 5 batches based on the Start of bach which is a time stamp it takes a long time.
Here is the query i use
FROM rets AS d
WHERE d._type = “batch_info”
ORDER BY d.
even so the filed Start and _type are covered via Index it has no impact on the sort.
CREATE INDEX adv_Start ON rets
) WHERE (_type
What index do i need to create to be able to get the Top 5 ASC or DESC based on Start Time ?