Miscellaneous Notes

Dynamic SQL Statement Caching is a feature within Db2 which allows for optimized (prepared) dynamic SQL statements to be saved for reuse. When such a prepared statement is cached and subsequently re-executed, the cost and time required to re-optimize the same dynamic SQL statement is saved. ................
................