SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Forcing Execution Plans
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
5-12
Forcing Group By Operations to the Data Access
Manager
Consider this query against an EMPLOYEE table that contains 50,000 rows
(employees) and uses 18 partitions:
SELECT COUNT(*) FROM EMPLOYEE;
When the compiler presents a query plan like the plan shown in Figure 5-2, the SCAN
operator passes messages in blocks to the EXCHANGE node. The EXCHANGE node
passes the messages to the GROUP BY operator.
TP663851.fm Page 12 Wednesday, January 30, 2013 5:37 PM