My purpose is to make pagination for a table that selects from a large database. I need to jump to any page number (if the page size is 99 and I want to display the 111th page, I need to select as fast as possible the rows between10989 and 11088).
I used %VID BETWEEN :from and :to for the select query. Now, the %VID is available only if I select either from another nested select, or from a view. %VID does not work if I select directly from a table.
By likes