APREUSESOURCE bind option

The APREUSESOURCE bind option, when used with the APREUSE bind option, specifies which package copy to use for EXPLAIN information for access path reuse processing.

Command option	Option values	Used with
APREUSESOURCE	(CURRENT ) (PREVIOUS) (ORIGINAL)	REBIND PACKAGE ¹ REBIND TRIGGER PACKAGE

Note:

The APREUSESOURCE bind option is not valid for REBIND of packages for advanced triggers.

Option descriptions for APREUSESOURCE

You can use the APREUSESOURCE bind option to specify which package copy is used for access path reuse when the APREUSE option is specified.

(CURRENT): The EXPLAIN information that is stored in the current package copy is used for access path reuse processing.
(PREVIOUS): The EXPLAIN information that is stored in the previous package copy is used for access path reuse processing.
(ORIGINAL): The EXPLAIN information that is stored in the original package copy is used for access path reuse processing.