Index Re-org

Posted in 1997

Rick Ward — 14 Jan 1997 11:38:43 -0500 — source: Informix-list mailing list archive (1991-1998)

Using: ONLINE DSA V7.13 Can anyone tell me if they re-organise indexes on tables automatically ? If you do, do you: 1. Schedule it periodically (weekly, daily, etc) 2. Schedule it automatically (when some statistic gets beyond a tolerance level) 3. Run the script unattended 4. Have an example script/pseudo-code I would be grateful for any help, -- Rick Ward Senior DBA Great Universal Stores Home Shopping MANCHESTER, UK