Re: What hint would you try?

From: Kerry Osborne <kerry.osborne_at_enkitec.com>
Date: Thu, 9 Jun 2011 16:10:53 -0500
Message-Id: <7A05DD7C-B54E-4E34-B249-20D006B710F5_at_enkitec.com>

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

Received on Thu Jun 09 2011 - 16:10:53 CDT

This message: [ Message body ]
Next message: Eugene Pipko: "date format mask?"
Previous message: Bobak, Mark: "RE: anyway to restart mmon after database shutdown is cancelled?"
In reply to: Wolfgang Breitling: "Re: What hint would you try?"
Next in thread: Chris Dunscombe: "Re: What hint would you try?"
Reply: Chris Dunscombe: "Re: What hint would you try?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message