FW: Fragmentation opinion wanted.

Posted in 2000

Martin, Wayne E. — Thu, 9 Mar 2000 16:11:24 -0500 — source: Informix-list mailing list archive (1991-1998)

Is the application using rowid or not. If yes, then creating tables with the rowid option has caused problems on Informix fragmented tables in the past. Doing it in dbspaces will cause more DBA maintenance work. I myself like to split the database into two areas static tables and dynamic tables. The use a good disk array with disk stripping. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Paul Howard [mailto:paulhoward@home.com] Sent: Thursday, March 09, 2000 1:03 PM To: informix-list@iiug.org Subject: Fragmentation opinion wanted. Importance: High We have IDS 7.31 and AIX 4.3 I am being told by my software vendor that I should not fragment tables using Informix fragmentation. They say that it would be better for me to optimize my system by spanning dbspaces across multiple disks and letting the hardware fragment the table. This is contrary to my experince and schooling. Can anyone tell me how much merit this statement of my software vendor has?