com Identificações: update_statistics X
IngeHalilovic Identificações: administration assertion_failure informix update_statistics backup prevention 1.841 Visitas
In my previous entry, I gave some tips on how to correct assertion failures in the Informix® server. Obviously, the real goal is to prevent them in the first place! Here are some things you should do on a regular basis that might prevent assertion failures:...
96QY_Pat_Smith Identificações: informix database index update_statistics ustlow_sample statistics_low 11.70 1.711 Visitas
If you upgrade to IBM Informix Version 11.70xC4, you can generate index statistics based on sampling when you run UPDATE STATISTICS statements in LOW mode. For an index with more than 100 K leaf pages, the gathering of statistics using sampling can increase...