Thank you for your answer; I can see difference using limit/offset but only with small offset values, when offset is, fo example, 3000 the query is slow.I also performed what you suggested but I cannot see any difference.From the logs, I can see that the sql query is executed ordering the results ar...