Database Tuning (MOSC)

MOSC Banner

Discussions

Oracle pagination query runs longer when OFFSET value is higher


Oracle pagination query runs longer when OFFSET value is higher

-- slower (~10s):

OFFSET 8602 ROWS FETCH NEXT 41 ROWS ONLY

-- faster (~1s):

--OFFSET 0 ROWS FETCH NEXT 41 ROWS ONLY

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.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center