trying to get the time of analysis for tables in SAP

[Former Member]

Hi all,

I'm using the update statistics command on some tables in my database.

The num_rows attribute in the user_tables is updated after that but the last_analyzed attribute is not updated correctly.

Does anyone know how ? or maybe a different way to get the time the table was analyzed ?

Thanks,

lital

[Former Member]

Dear Lital,

Can you please specify the Database system you are using and the version?

Thanks

N.P.C

[Former Member]

Hi,

I'm using SAP database of version 7.4.

Thanks for your help,

Lital