Re: What hint would you try?

From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
To: breitliw@xxxxxxxxxxxxx
Date: Thu, 9 Jun 2011 16:10:53 -0500

Amen to the second suggestion brother.

Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com






On Jun 9, 2011, at 3:52 PM, Wolfgang Breitling wrote:

> For hints NO_UNNEST and NO_MERGE come to mind.
> 
> I would also try what you get when you replace the ANSI  join syntax with the 
> "traditional" Oracle join syntax. The optimizer doesn't speak ANSI very well.
> 
> On 2011-06-09, at 2:28 PM, Ethan Post wrote:

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: What hint would you try?
From: Chris Dunscombe

References:
- What hint would you try?
  - From: Ethan Post
- Re: What hint would you try?
  - From: Wolfgang Breitling

Re: What hint would you try?

Other related posts: