issues with sql baselines
SELECT DISTINCT /*+ INDEX (l KS_LEDGER_1PK) */ a.acct_num
FROM PATRON.ST_LEDGER_AVAIL_FUNDS a, ks_acct_ledger al, ks_ledger l
WHERE A.ACCT_NUM = l.acct_num
AND al.ledger_id = l.id
AND l.balance > 0
/
and i get its sql_id as 3xs2m3rvk5q71
when I look for the baseline for this sql_id i cant find it.
SELECT sql_handle, plan_name
FROM dba_sql_plan_baselines
WHERE signature IN (SELECT exact_matching_signature FROM v$sqlarea WHERE sql_id='3xs2m3rvk5q71');
no rows found.