Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Martin, Wayne E. — — 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?
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.