Re: What hint would you try?

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 10 Jun 2011 07:41:39 -0600
Message-Id: <D5195F50-6B60-4926-873C-0A7B4C79DE07_at_centrexcc.com>

I should have added - neither do I.

When a developer comes to me for help tuning a sql with ANSI join syntax and I can't see the solution within about 5 minutes I tell them to come back with the sql rewritten in Oracle join syntax because neither I nor the optimizer speak ANSI.

On 2011-06-10, at 7:33 AM, Wolfgang Breitling wrote:

> the optimizer as of current doesn't understand it very well

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

Received on Fri Jun 10 2011 - 08:41:39 CDT

This message: [ Message body ]
Next message: Joel.Patterson_at_crowley.com: "Metalink"
Previous message: Patrice sur GMail: "startup scripts for Fusion 11g pfrd"
In reply to: Wolfgang Breitling: "Re: What hint would you try?"
Next in thread: Kerry Osborne: "Re: What hint would you try?"
Reply: Kerry Osborne: "Re: What hint would you try?"
Reply: Adric Norris: "Re: What hint would you try?"

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

Original text of this message