Re: Parallel hint ignored only in subquery
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 25 Jul 2008 08:30:53 -0500 (CDT)
Message-ID: <14560.12.17.117.251.1216992653.squirrel@12.17.117.251>
Date: Fri, 25 Jul 2008 08:30:53 -0500 (CDT)
Message-ID: <14560.12.17.117.251.1216992653.squirrel@12.17.117.251>
I was just using the Oracle docs for my source:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/queries007.htm
"A subquery in the FROM clause of a SELECT statement is also called an inline view."
Thanks for the hints, so to speak!
Rich
> I think that's true in a general sense, however the hint syntax makes
> the distinction because there is a big difference to the optimizer
> between the two constructions, and between the two transformations that
> can be applied to them.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 25 2008 - 08:30:53 CDT