Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Does using "fetch first N rows only" make /*+ FIRST_ROWS([N]) */ hint redundant?

user65579Oct 2 2013 — edited Oct 3 2013

I know the FIRST_ROWS hint tells the optimizer to minimize time to first row.  I know the new 12c functionality for "FETCH [FIRST|NEXT] [N] ROWS [ONLY|WITH TIES]"fetch first/next N rows only/with ties" will implement the query using ROW_NUMBER().  Should I leave hint in case it improves performance, or does the FETCH FIRST clause make this hint redundant?
This post has been answered by Vite DBA on Oct 3 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2013
Added on Oct 2 2013
#query, #tuning
9 comments
4,998 views