My Oracle Support Banner

Poor Discoverer Query Performance When SQL Query Uses Optimizer Hints (Doc ID 435188.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.2 and later
Information in this document applies to any platform.
***Checked for relevance on 19-May-2011***
***Checked for relevance on 12-Nov-2012***
Feb 2016

Symptoms

After upgrading Discoverer to 10.1.2.54.25, Discoverer optimizer hints <all_rows> or <first_rows> are
being added to sql statements and the query performance becomes very slow against RBO Database.

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!


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