Caches across temporary databases within a group should be configured similarly to each other with respect to caching characteristics. The optimizer considers the caching characteristics of a database when selecting an efficient query plan. If the plan is part of a procedure, it may be reused by another session that has been assigned to a different temporary database. Poor performance may result if the caching characteristics of the two temporary databases vary significantly.
