work_t

Description

Describes a stored worktable.

Syntax

( work_t [ worktable_name 
             | (correlation_name worktable_name) ]
)

Parameters

worktable_name

is the name of a worktable.

correlation_name

is the correlation name specified for a worktable, if any.

Returns

A stored table.

Examples

Example 1

select c12, max(c11) from t1
    group by c12

( plan 
    ( store Worktab1 
        ( t_scan t1 ) 
    ) 
    ( t_scan ( work_t Worktab1 ) ) 
)

Specifies the two-step process of selecting vector aggregates into a worktable, then selecting the results of the worktable.

Usage

See also

store, view