script or spl for update statistics

Posted in 1997

Zeljan Silje — 3 Sep 1997 09:48:33 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, in Informix Guide To SQL Syntax there is recommendation for updating statistics: 1) run update statistics with distributions only 2) run update statistics high for columns with indexes 3) run update statistics low for multicolumn indexes I would like to do recommended update statistics regularly (via cron). Does anybody has SPL or script (or anything convenient) that is able to do such a update. +--------------------------------------------------------+ | CC Computer Consulting d.o.o. | +--------------------------+-----------------------------+ | Zeljan Silje | e-mail: zeljan@laus.hr | | CC Computer Consulting | Tel: +385 (20) 411-136 | | Janjevska 15 | +385 (1) 6552-330 | | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | | Hrvatska (Croatia) | URL: http://www.laus.hr | +--------------------------+-----------------------------+