|Pagination - FIRST_ROWS_N [message #984557]
||Wed, 14 November 2012 20:09
| Mauro Flores
Registered: September 2009
How to create a JPA query with pagination parameters (setFirstRows and setMaxRows) and obtain a SQL query like this to run on oracle data base: |
SELECT * FROM (SELECT /*+ FIRST_ROWS_10 / a., ROWNUM rnum FROM (...)
Today the SQL query is generated like:
SELECT * FROM (SELECT /*+ FIRST_ROWS / a., ROWNUM rnum FROM (...)
The second way is far slower than the first.
Is there a query hint to make this customization? I'm using eclipselink 2.1.3.
Thanks. Mauro Flores.
[Updated on: Wed, 14 November 2012 20:10]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.05316 seconds