Range Hint slowing the DQL query

NewtoDQL

Hi,

I have used Range hint on a query and it has slowed down the query. (ENABLE (RETURN_RANGE 1 10 10 'r_modify_date DESC')))

If i remove the range hint ,query works very fast. How can i speed up the query while keeping the range hint enabled?

Thanks in advance.

DCTM_Guru

Depending on how many pages you expect, it might be more efficient to return all the results and have the application take care of paging.