COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
RUNID NUMBER No null 1 null NO NO NO
ALL_TABLES VARCHAR2(2000) Yes null 2 null NO NO NO
FACT_TABLES VARCHAR2(1000) Yes null 3 null NO NO NO
GROUPING_LEVELS VARCHAR2(2000) Yes null 4 null NO NO NO
QUERY_TEXT LONG() Yes null 5 null NO NO NO
RECOMMENDATION_NUMBER NUMBER No null 6 null NO NO NO
RECOMMENDED_ACTION VARCHAR2(6) Yes null 7 null NO NO NO
MVIEW_OWNER VARCHAR2(30) Yes null 8 null NO NO NO
MVIEW_NAME VARCHAR2(30) Yes null 9 null NO NO NO
STORAGE_IN_BYTES NUMBER Yes null 10 null NO NO NO
PCT_PERFORMANCE_GAIN NUMBER Yes null 11 null NO NO NO
BENEFIT_TO_COST_RATIO NUMBER No null 12 null NO NO NO