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


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.