Defregmenting a large table

Posted in 2000

Neil Truby — Tue, 5 Dec 2000 15:26:37 -0000 — source: Informix-list mailing list archive (1991-1998)

HP_UX 11.0; IDS 9.20 I have a large table, about 25GBytes in size, from which I've deleted quite an amount of data and wish to defragment. Normally I'd use ALTER FRAGMENT ....INIT, and may in fact do so, although in initial testing I had some better results with HPL. My question is, does anyone have any usual hints and tips, or perhaps a FAQ, concerning MAXPDQPRIORITY, PSORT_NPROCS and the like for this type of exercise? thanks Neil