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 tab -> 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.
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 .The date seen in the Last Analyzed column seen from the View tab -> Explore Analysis Group comes from column quest_spc_stat.last_update. The date you see in the Last Analyzed column from the Manage table -> Open Analysis Group comes from column dba_tables.last_analyze. The Last Analyzed field at the bottom of the screen of the Object Properties, Statistics Tab is column quest_spc_space_info.last_analyzed, which is populated from dba_tables.last_analyzed when you run the nightly repository job
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center