Description:
When using option 12 Problem SQL, does PPA read the Plan table to populate that panel or getting the info from somewhere else like catalog?
Solution:
This option does not read the plan_table, but rather the PPA historical database tables(PTPA_ES_EXPL_1200, PTAN_STMT_1200, PTAN_SQL_1200, etc...)
Option 12 reporting is a PPA Historical Database report. An explain with Historical Database explain option set needs to be done to get the explain data saved into the PPA historical database in order to be able to use this reporting option. Otherwise you'll end up with the following message: PP028E: NO DATA WAS FOUND MATCHING THAT CRITERIA.