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

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 hundreds of Community platforms