VIEW: SYS._BASE_OPT_FINDING

Source

View Text - Preformatted

SELECT
    f.f_id,
    f_own#,
    decode(f.type, 1, 'OPTIMIZER_BAD_DECISION', 'UNKNOWN'),
    decode(f.reason, 1, 'SINGLE TABLE CARDINALITY MISESTIMATE',
                     2, 'JOIN CARDINALITY MISESTIMATE',
                     3, 'QUERY BLOCK CARDINALITY MISESTIMATE',
                     4, 'GROUP BY CARDINALITY MISESTIMATE',
                     5, 'HAVING CARDINALITY MISESTIMATE',
                     6, 'SPREADSHEET CARDINALITY MISESTIMATE',
                        'UNKNOWN'),
    cast(f.ctime as timestamp),
    f.tab_cnt
FROM
    sys.opt_finding$ f

View Text - HTML Formatted

SELECT F.F_ID
, F_OWN#
, DECODE(F.TYPE
, 1
, 'OPTIMIZER_BAD_DECISION'
, 'UNKNOWN')
, DECODE(F.REASON
, 1
, 'SINGLE TABLE CARDINALITY MISESTIMATE'
, 2
, 'JOIN CARDINALITY MISESTIMATE'
, 3
, 'QUERY BLOCK CARDINALITY MISESTIMATE'
, 4
, 'GROUP BY CARDINALITY MISESTIMATE'
, 5
, 'HAVING CARDINALITY MISESTIMATE'
, 6
, 'SPREADSHEET CARDINALITY MISESTIMATE'
, 'UNKNOWN')
, CAST(F.CTIME AS TIMESTAMP)
, F.TAB_CNT FROM SYS.OPT_FINDING$ F