New load execution plans and query plan nodes in SAP Sybase IQ 16.0.
The Interactive SQL Query Plan Viewer now supports SAP Sybase IQ load execution plans. Load execution plans detail the steps that the database engine uses to insert data into a table.
Load plans use the same database options as query execution plans. Text versions of the plan are written to the .iqmsg file. HTML versions include a Data Flow Object (DFO) tree that identifies the number of rows processed at each stage of the load. Different SQL statements generate different DFO trees and the same statement may generate different trees for different kind of tables (un-partitioned, range partitioned, hash partitioned, hash-range partitioned, etc.).
To generate a load plan, set the appropriate QUERY_PLAN options, then use the Interactive SQL Query Plan Viewer to create the plan.
| Node Change | Description |
|---|---|
| Distinct Sort (inserter) | New node indicating early aggregation algorithm is used. |
| Distinct Sort (retriever) | New node indicating early aggregation algorithm is used. |
| Grouping Sort (inserter) | New node indicating early aggregation algorithm is used. |
| Grouping Sort (retriever) | New node indicating early aggregation algorithm is used. |
| Join (Asymmetric Sort-Merge) | New node indicating an asymmetric sort-merge join is used. |
| Join (Asymmetric Sort-Merge PushDown) | New node indicating an asymmetric sort-merge join is used. |
| Order By (Full Rewind) | New node indicating an asymmetric sort-merge join is used. Displays on the right branch of a Join (Asymmetric Sort-Merge) node. |
| Order By (Per-Work-Unit) | New node indicating an operator that performs a sort on a work-unit worth of data. For example, it displays on the left branch under a Join (Asymmetric Sort-Merge) node. |