Neoview Query Guide (R2.2)

• “NESTED_ANTI_SEMI_JOIN Operator” (page 38)
• “NESTED_JOIN Operator” (page 37)
• “NESTED_SEMI_JOIN Operator” (page 37)
• “ORDER_CROSS_PRODUCT” (page 46)
• “ORDERED_HASH_ANTI_SEMI_JOIN” (page 45)
• “ORDERED_HASH_JOIN Operator” (page 44)
• “ORDERED_HASH_SEMI_JOIN Operator” (page 44)
• “PARTITION_ACCESS Operator” (page 35)
• “ROOT Operator” (page 33)
• “SEQUENCE Operator” (page 62)
• “SIDETREE_INSERT Operator” (page 48)
• “SHORTCUT_SCALAR_AGGR Operator” (page 58)
• “SORT Operator” (page 58)
• “SORT_GROUPBY Operator” (page 58)
• “SORT_PARTIAL_AGGR_LEAF Operator” (page 59)
• “SORT_PARTIAL_AGGR_ROOT Operator” (page 59)
• “SORT_PARTIAL_GROUPBY_LEAF Operator” (page 60)
• “SORT_PARTIAL_GROUPBY_ROOT Operator” (page 60)
• “SORT_SCALAR_AGGR Operator” (page 60)
• “SPLIT_TOP Operator” (page 36)
• “SUBSET_DELETE Operator” (page 51)
• “SUBSET_UPDATE Operator” (page 49)
• “TRANSPOSE Operator” (page 61)
• “TUPLE_FLOW Operator” (page 39)
• “TUPLELIST Operator” (page 63)
• “UNIQUE_DELETE Operator” (page 52)
• “UNIQUE_UPDATE Operator” (page 50)
• “UNPACK Operator” (page 63)
• “VALUES Operator” (page 63)
Operators listed here might appear occasionally or might not appear at all in Neoview query
execution plans:
• “COMPOUNDSTMT Operator” (page 64)
• “EXPLAIN Operator” (page 64)
• “PACK Operator” (page 64)
• “SAMPLE Operator” (page 65)
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 33)
• “ESP_EXCHANGE Operator” (page 34)
• “PARTITION_ACCESS Operator” (page 35)
• “SPLIT_TOP Operator” (page 36)
32 Query Plan Operators