IBM Informix 11.70 System Administrator Set 4

UPDATE STATISTICS HIGH scans the entire table. ✘ Data distributions are updated every time UPDATE STATISTICS LOW is executed. ✘ UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable. ✘ An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE. ✔

ADM ✘ BTS ✘ CPU ✘ CSM ✔

110% of rootdbs. ✘ 110% the default buffer pool. ✘ 110% of the logical log space. ✘ 110% of combined buffer pool. ✔

Logical Log ✘ Physical Log ✘ External Tables ✘ Temporary DBSpaces ✔

Use a commercial storage manager. ✘ Use the bundled Informix Storage Manager (ISM). ✘ Use a combination of disk-based and tape-based backup devices. ✘ Use separate storage devices for instance spaces and logical logs. ✔