Symptom
Customer saw a DQP query processing was slow with many retries in work-units.
Below copy is part of customer's HTML Plan.
#181 Order By | |
---|---|
Generated Result Rows | 85 |
Estimated Result Rows | 14,440,014 |
Fragment ID | 2 |
Optimization Note | Parallel sort load |
Work Units - nodexx1 | 53 (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0) |
Work Units - nodexx3 | 32/30 (1, 1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 0) |
Max. Possible Parallel Arms | 96 |
Max. Active Parallel Threads | 85 |
Parallel Sink Work Units | 85 |
First Worker Work Unit | 29 |
Read more...
Environment
SAP IQ 16.0
Product
SAP IQ 16.0
Keywords
"Retry work unit" ; "Retry workunit" ;"Retry work-unit" ;"DQP retry" ; , KBA , BC-SYB-IQ , Sybase IQ , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.