Hello..

Are there one view to check if one table is updated with statistics and what statistic was executed on it ?


Att,
Fernando.

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

I run it.. and see two statistics in my database.

I no see low mode...

My statistic's ok ?


tabname constructed mode

estoque_trans 2008-01-16 H
estoque_trans 2008-01-16 M

2 Row(s) affected

Informix does not report low mode statistics. Low mode is more like updating the system with the row counts of the tables.

Your statistics are perfect.....!!!!

IDS 11.10 - systables:ustlowts
Before IDS 11.10 - don't have