Database Tuning (MOSC)

MOSC Banner

first rows hint

edited May 1, 2012 11:55PM in Database Tuning (MOSC) 4 commentsAnswered
We are on 10204 and Solaris 10.

I've seen this hint on number of our SQL queries but I'm not sure if this is correct hint.

SELECT /*+ FIRST_ROWS(5000) */ OID, NAME, USER_ID, SERVICE_ID, GROUP_ID, SUBSCRI

I've read about FIRST_ROWS_1 , FIRST_ROWS_10, FIRST_ROWS_100 ,AND FIRST_ROWS_1000 but I've not heard of     FIRST_ROWS(5000). Is that a valid hint, if not then what could be the right hint?

THanks

Mukul

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center