The SQL optimizer is predictive and selects from a list of plans based on the estimated execution time. Each input parameter used can influence the estimate of the plan and change plan selection between runs of the query. This document describes the parameters that affect query performance and an introduction to diagnosing query performance issues. Read More
Get empowered with IBM Power
