If you have enabled dump and load to the same group, without replace mode enabled:
If a valid plan exists for the query, it is loaded and used to optimize the query.
If a plan exists that is not valid (for example, because an index has been dropped), a new plan is generated and used to optimize the query, but is not saved.
If only a partial plan exists, a full plan is generated, but the existing partial plan is not replaced
If a plan does not exist for the query, a plan is generated and saved.
With replace mode also enabled:
If a valid plan exists for the query, it is loaded and used to optimize the query.
If the plan is not valid, a new plan is generated and used to optimize the query, and the old plan is replaced.
If the plan is a partial plan, a complete plan is generated and used, and the existing partial plan is replaced. The specifications in the partial plan are used as input to the optimizer.
If a plan does not exist for the query, a plan is generated and saved.
