g_join

Description

Specifies the join of two or more abstract plan derived tables without specifying the join type (nested-loop or sort-merge).

Syntax

( g_join derived_table1 derived_table2
)
( g_join    ( derived_table1 )
                ( derived_table2 )
                 ...
                ( derived_tableN )
)

Parameters

derived_table1...derived_tableN

are the abstract plan derived tables to be united.

Returns

An abstract plan derived table that is the join of the specified abstract plan derived tables.

Examples

Example 1

select *
from t1, t2
where c21 = 0
and c22 = c12

( g_join
    ( i_scan i_c21 t2 )
    ( i_scan i_c12 t1 )
)

Table t2 is the outer table, and t1 the inner table in the join order.

Example 2

select *
from t1, t2, t3
where c21 = 0
and c22 = c12
and c11 = c31

( g_join
    ( i_scan i_c21 t2 )
    ( i_scan i_c12 t1 )
    ( i_scan i_c31 t3 )
)

Table t2 is joined with t1, and the abstract plan derived table is joined with t3.

Usage

See also

m_g_join, nl_g_join