New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Explain in the manual why LIMIT .. OFFSET emulation for Oracle uses ROWNUM instead of ROW_NUMBER() OVER() #4413

Closed

lukaseder opened this issue Jul 15, 2015 · 0 comments

Labels

C: DB: Oracle C: Documentation P: Medium R: Fixed T: Enhancement

Milestone

Member

lukaseder commented Jul 15, 2015

Add this paragraph to the manual:

Side-note: If you're interested in understanding why we chose ROWNUM for Oracle, please refer to this very interesting benchmark, comparing the different approaches of doing pagination in Oracle: http://www.inf.unideb.hu/~gabora/pagination/results.html.

See also:
https://groups.google.com/forum/#!topic/jooq-user/27DNyVKlYw0

lukaseder added T: Enhancement C: DB: Oracle C: Documentation P: Medium labels

lukaseder added this to the Version 3.7.0 milestone

lukaseder added the R: Fixed label

lukaseder closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment