Member Avatar for litalh

Hi,
I'm using update statistics command to analyze a table and would like to know later when this table was analyzed.
I saw that in the user_tables table the num_rows coulmn was changed but the last_analyzed coulmn was not changed.
Does anyone know if last_analyzed coulmn should be changed and if so why it didn't ? or maybe there is another way to get this information for sap db ?
thanks alot,
lital

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 18 Years Discussion Span
  • Latest Post Latest Post by peol
Member Avatar for peol

To check when update statistics was last performed on an SAP table, use database-specific queries! For SAP HANA, check M_TABLES.LAST_COMPILED. In SQL Server, use STATS_DATE. For Oracle, check DBA_TAB_STATISTICS.LAST_ANALYZED. In DB2, use SYSCAT.TABLES.STATS_TIME. Stay optimized, stay ahead!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.