last update statistics time/date

GoldenBoy · #1 (**permalink**) 09-29-03, 13:34

Can anyone tell me how to tell when the last time update statistics was run for a table (or all tables)? I was surprized that this wasnt in the online.log, but I am new to informix. thx

lloydnwo · #2 (**permalink**) 09-29-03, 23:52

Quote:

Originally posted by GoldenBoy
Can anyone tell me how to tell when the last time update statistics was run for a table (or all tables)? I was surprized that this wasnt in the online.log, but I am new to informix. thx

Hi there,

Try the below statement

select distinct tabname, b.constructed, b.mode
from systables a, sysdistrib b
where a.tabid=b.tabid
order by 1

Regards,

lloyd

Internet Services

Web Development

Digital Marketing

Consumer Tech