Tag Archives: TOP N and Pagination

Oracle 12c TOP N Pagination performance considerations.

In my post on TOP N and Pagination in Oracle 12c highlighted features introduce. In current post will try to compare performance and cardinality estimations for a scenario between INLINE ORDER BY + OUTER ROWNUM and TOP N IN 12C. … Continue reading

Rate this:

Posted in Oracle 12c New Features, Oracle Internal | Tagged , , , , , | 1 Comment

TOP N and Pagination in Oracle 12c

Other than Oracle, most of OLTP Databases already had set of SQL syntax for fetching Top N. In Oracle Database 12c includes support for the ANSI-standard FETCH FIRST/NEXT and OFFSET clauses—together called the row limiting clause. Syntax for the same … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , , | 3 Comments