Re: ordered_hint

William Robertson wrote:
>
>
> http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/hintsref.htm#PFGRF50104
>
> The outcome depends on whether the view can be merged, among other
> things.
>

"The ORDERED hint causes Oracle to join tables in the order in which they appear in the FROM clause."

But what if not all the tables are in the FROM clause of the query that has the ORDERED hint on it? Like in my example where one of the "tables" is actually a view. It doesn't specify how what the hint does with tables brought into the query by a view. That's what I was hoping to find some officially documented word on. Maybe I should ask Tom. :-)

-- 
To reply by email remove "_nospam"