I've seen numerous examples over the web that show how to page through a large result set returned by a JPA query. I'm wondering why this works. From what I understand, sql queries are NOT ...

It is more efficient to omit the ORDER BY clause when you are creating the view and specify it as needed when you reference the view in queries. Note: If you specify the NUMBER option in the PROC SQL ...