The SQL Plan Cache is a key operational construct at the center of DB2 for i query operations. The plan cache exists on every IBM i machine and gets used to ensure that query implementation is done as efficiently as possible when SQL queries are executed with the SQL Query Engine (SQE). Access plans are stored in a database-wide cache where they become eligible to be reused by any job executing the same or a similar query. This notion of building plans once and reusing them many times is a ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.