Operators for Hierarchical Tables

  • Article

Note

Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.

 

The following list describes the operators for hierarchical tables.

DBOP_navigate

Given two tables, one or both of which may be hierarchical tables, this operator computes their join. However, instead of creating large rows with columns from both join inputs, it attaches to each row of the first table all matching rows from the second table, thus creating a hierarchy of rowsets. It also adds expression-valued columns to both the new parent rowset and the new child rowset.

This operator has six inputs:

  • Two table-valued subtrees representing the input to the operator.
  • A join predicate to make the connection.
  • A list element with a name for the new column representing the nested column. The alias name for child levels is mandatory and must be unique across the hierarchy.
  • A list specifying expression-valued columns to be added to the parent level (such as sub-totals).
  • A list adding expression-valued columns to the child level (such as running sums).