Push_subq Oracle hint - Execute the sub query before the parent query

Revision: 28396

at July 12, 2010 23:18 by mprabhuram

Updated Code

/*+ push_subq(@subq1)*/
 
/*+ no_unnest qb_name(subq1) */

Revision: 28395

at July 7, 2010 22:13 by mprabhuram

Initial Code

/*+ push_subq */

Initial URL

http://jonathanlewis.wordpress.com/2007/03/09/push_subq/

Initial Description

Initial Title

Push_subq Oracle hint - Execute the sub query before the parent query

Initial Tags

Oracle

Initial Language

SQL