Re: Optimizer ignoring hints

From: Jonathan Lewis <>
Date: Sat, 14 Sep 2013 06:53:20 +0100
Message-ID: <DA049E066278420EA886ACC828CD6862_at_Primary>

It's just possible that if you gave the critical subquery a qb_name (or worked out the name that Oracle had given it - which would be something like sel$5) then referencing the objects with their query block names would be sufficient to make the hint valid. It's not a proper solution, though.


Jonathan Lewis

Author: Oracle Core (Apress 2011)

  • Original Message ----- From: "Jonathan Lewis" <> To: "'ORACLE-L'" <> Sent: Saturday, September 14, 2013 6:47 AM Subject: Re: Optimizer ignoring hints

| Your hints "leading" and "use_nl" hints are invalid - they refer to
| that aren't in the query block where you've put the hint (and because of
| the nature of the leading hint you can't put it into the query block that
| is going to be unnested to make it possible for flv to be the leading
| in the join order).

Received on Sat Sep 14 2013 - 07:53:20 CEST

Original text of this message