Dynamic plan stability – a Db2 12 greatest hit with John Campbell

Dynamic SQL statements are more susceptible to creating performance problems than static SQL. A full PREPARE occurs for every miss in the dynamic statement cache, and such SQL statements might go through query optimization several times per day.

Register to Read