Check the multiplex node directories to review the query plan. The comprehensive query plan is in the leader node directory, and each distributed work unit has an HTML file generated by the node that received it.
To open the query plan in a Web browser, double-click the leader node directory. The query plan is represented visually by a structure called the query tree.
Query Tree
A query tree represents the query’s data flow, and the query tree consists of nodes that represent a stage of work. Each node has a name and a data flow operator (DFO) number. All nodes in the tree are hyperlinked to more detailed information.
The lowest nodes on the tree are leaf nodes. Each leaf node represents a table or a prejoin index set in the query. At the top of the plan is the root of the operator tree. Information flows up from the tables and through any operators representing joins, sorts, filters, stores, aggregation, and subqueries.
The three vertical bars that connect the query operators indicate distribution. For example, between the group by node and the join, the three bars indicate that this operation occurs over parallel threads and is distributed over multiple servers. The operation between the join and leaf #01 is also distributed.