News
Abstract
Following in the tradition of continued investment in the SQL Query Engine (SQE), IBM i 7.5 includes enhanced CPU costing within SQE.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > SQE - Improved CPU costing
As a cost-based optimizer, SQE looks at many aspects to make the best decision (plan) when optimizing a query.
Costs for a given plan represent the estimated time required by:
- Any I/O operations
- The CPU for computing and processing the result set
The plan with the lowest overall estimated execution time is used for the query.
With IBM i 7.5, SQE has improved CPU costing:
- Adaptations in counting heuristics to align with advancements in Power processing technology
- Creation of an automated modeling process
Simply by moving to IBM i 7.5, production workloads will benefit from advancements in SQE optimization.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
03 May 2022
UID
ibm16579155