Neoview Query Guide (R2.3, R2.4, R2.5)

• “MERGE_UNION Operator” (page 50)
• “NESTED_SEMI_JOIN Operator” (page 25)
• “NESTED_JOIN Operator” (page 25)
• “NESTED_SEMI_JOIN Operator” (page 25)
• “ORDER_CROSS_PRODUCT” (page 34)
• “ORDERED_HASH_ANTI_SEMI_JOIN” (page 33)
• “ORDERED_HASH_JOIN Operator” (page 31)
• “ORDERED_HASH_SEMI_JOIN Operator” (page 32)
• “PARTITION_ACCESS Operator” (page 22)
• “ROOT Operator” (page 20)
• “SEQUENCE Operator” (page 51)
• “SIDETREE_INSERT Operator” (page 36)
• “SHORTCUT_SCALAR_AGGR Operator” (page 47)
• “SORT Operator” (page 47)
• “SORT_GROUPBY Operator” (page 47)
• “SORT_PARTIAL_AGGR_LEAF Operator” (page 48)
• “SORT_PARTIAL_AGGR_ROOT Operator” (page 48)
• “SORT_PARTIAL_GROUPBY_LEAF Operator” (page 48)
• “SORT_PARTIAL_GROUPBY_ROOT Operator” (page 49)
• “SORT_SCALAR_AGGR Operator” (page 49)
• “SPLIT_TOP Operator” (page 23)
• “SUBSET_DELETE Operator” (page 39)
• “SUBSET_UPDATE Operator” (page 37)
• “TRANSPOSE Operator” (page 50)
• “TUPLE_FLOW Operator” (page 27)
• “TUPLELIST Operator” (page 52)
• “UNIQUE_DELETE Operator” (page 40)
• “UNIQUE_UPDATE Operator” (page 38)
• “VALUES Operator” (page 52)
Operators listed here might appear occasionally or might not appear at all in Neoview query
execution plans:
• “COMPOUNDSTMT Operator” (page 53)
• “EXPLAIN Operator” (page 53)
• “PACK Operator” (page 53)
• “SAMPLE Operator” (page 54)
• “UNPACK Operator” (page 54)
Operators and Description Fields
This section includes the description field for all Neoview SQL operators. Some items in the
description field do not appear constantly; that is, the items are present only when certain
conditions exist in the optimization of the plan.
Operators Used for Parallelism or as Process Boundaries
Certain operators are called the exchange operators and are used to show parallelism in query
plans. These operators include:
• “ROOT Operator” (page 20)
• “ESP_EXCHANGE Operator” (page 21)
18 Query Plan Operators