Glossary

Plan Reuse

DB2 compiles the SQL once and caches the access plan in the package cache. Subsequent executions with different parameter values reuse the plan, saving compilation overhead. On a busy system, this can reduce CPU usage by 20-40%.

Learn More

Related Terms