Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
UPDATE STATISTICS 1
- Thread starter similici
- Start date
-
1
- #2
Hi,
When statistics are updated with low keyword, information is not updated at sysdistrib table, hence no traces of timestamp is available. Keywords medium and high will generate columnwise data bins in distrib table.
Following SQL statement will show when & how the last update statistics were run, for medium or high mode only.
select distinct tabname, b.constructed, b.mode
from systables a, sysdistrib b
where a.tabid=b.tabid
order by 1
or can be generated through:
dbschema -d <database> -hd <tabname>
Regards,
Shriyan
"The learning and knowledge that we have, is, at the most, but little compared with that of which we are ignorant."
When statistics are updated with low keyword, information is not updated at sysdistrib table, hence no traces of timestamp is available. Keywords medium and high will generate columnwise data bins in distrib table.
Following SQL statement will show when & how the last update statistics were run, for medium or high mode only.
select distinct tabname, b.constructed, b.mode
from systables a, sysdistrib b
where a.tabid=b.tabid
order by 1
or can be generated through:
dbschema -d <database> -hd <tabname>
Regards,
Shriyan
"The learning and knowledge that we have, is, at the most, but little compared with that of which we are ignorant."
- Status