Future EXPLAIN for unqualified table

Document ID : KB000050820
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

A future explain for a package that had unqualified tables was executed, the target subsystem was different that the source. Plan Analyzer was able to determine the correct qualifier to use. No value was specified in the SQL qualifier panel. How is that possible?

Solution:

Explain will use the qualifier from SYSPACKAGE or SYSPLAN for catalog SQL Unless the user has requested through explain option SQL qualifier override that another qualifier be used instead for all unqualified objects.