How to check update statistics in Progress SQL-92


1. Check update table statistics
select t.tbl, s.VAL_TS 
from sysprogress.SYSTABLES t,sysprogress.SYSTBLSTAT s
where t.id = s.TBLID
and s.PROPERTY = 2;

2. Check update index statistics
select t.tbl, s.VAL_TS 
from sysprogress.SYSTABLES t,sysprogress.SYSIDXSTAT s
where t.id = s.TBLID
and s.PROPERTY = 2;

3. Check update column statistics
select t.tbl, c.col, s.VAL_TS 
from sysprogress.SYSTABLES t, sysprogress.SYSCOLUMNS c, sysprogress.SYSCOLSTAT s
where t.id = s.TBLID
and c.id = s.colid
and c.tbl = t.tbl
and s.PROPERTY = 2
order by s.colid;
-- Note: sysprogress.SYSCOLUMNS.id corresponds not to the Order in ABL Data Dictionay but to _Field._Field-Physpos.
-- Note: You will not see logical fields here. There is no logical data type in SQL

Return to myProgress Home Page
    

    

    

    

    

    

    

1