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 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


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


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