Dear all,
It is known that the OFFSET and LIMIT definitions work better with the ORDER BY clause, otherwise there is no guarantee that the result is ordered. Is this valid for sem_match queries? Also, when the result is too large, the performance of a query with ORDER BY is very slow.
So, is there a recommendation to improve query performance when using ORDER BY? Or is it better just not to use ORDER BY clause to do the pagination?
Thanks in Advance,
Elisa.