My Oracle Support Banner

Offset and Fetch Next With Literal Values Results in Incorrect Cardinality Estimates (Doc ID 2920645.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

Symptoms

The optimizer takes the literal  values of a "OFFSET 10 ROWS FETCH NEXT 100 ROWS ONLY" as granted for the cardinality estimate of this
If you provide those values in bind variables e.g. like "OFFSET :offset ROWS FETCH NEXT :next ROWS ONLY", the cardinality estimate is ok again.

Changes

 Upgrade from 12.1.0.1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.