The Last Analyzed field at the bottom of the screen of the Object Properties, Statistics Tab shows Last Analyzed: not analyzed . Where do the date in the "Last Analyzed" column seen from the view of menu bar -> Explore Analysis Group comes from column and the Last Analyzed field at the bottom of the screen of the Object Properties, Statistics Tab is column come from?
The "Last Analyzed" field at the bottom of the screen of the Object Properties, Statistics Tab comes from the value from column quest_spc_space_info.last_analyzed. This field is populated from dba_tables.last_analyzed when the nightly repository job ran (NOT the analysis group)
In version 8.0, the Analysis Group jobs are no longer needed as Space Manager will run the Internal update repository job to collect the necessary statistics for Reorg Need etc.
The date seen in the "Last Analyzed" column seen from the view of menu bar -> Explore Analysis Group comes from column quest_spc_stat.last_update. The date you see in the "Last Analyzed" column from the Manage of menu bar -> Open Analysis Group comes from column dba_tables.last_analyzed
The "Last Analyzed" field at the bottom of the screen of the Object Properties, Statistics Tab is column quest_spc_space_info.last_analyzed. This field is populated from dba_tables.last_analyzed when you run the nightly repository job (NOT the analysis group)
