Search notes:

Oracle SQL Plan operation: VIEW

The exection plan operation VIEW always has exactly one child operation and never has an «option».

Jonathan Lewis says about the VIEW operation that they

identify a separately optimized query block in [a] (possibly transformed) SQL – sometimes this will also mean that the result set of that piece of SQL will be completely built in memory before the next steps of the query plan take place but this is not necessarily the case.

TODO

Object names VW_…

`VW_CDG_`
`VW_COL_`
`VW_DAG_`	Distinct aggregation transform
`VW_DAT_`
`VW_DCL_`	Decorrelated lateral view
`VW_DIG_`
`VW_DIS_`
`VW_DTP_`	Distinct placement?
`VW_FOJ_`
`VW_FTG_`
`VW_GBC_`
`VW_GBF_`
`VW_JF_`
`VW_LAT_`
`VW_LT_`
`VW_NWVW_`	?
`VW_NSO`
`VW_ORE_`	Or expansion
`VW_RIG_`
`VW_RT_`
`VW_SJE_`
`VW_SQ_`
`VW_SSQ_`
`VW_ST_`	Star transformation
`VW_SQJ_`
`VW_TE_`	Table expansion
`VW_TEX_`
`VW_WIF_`

See also Jonathan Lewis' internal views.