RE: number of extents
I am in a new Informix shop and have been told that it is a very bad idea to
have a large first extent. They say the first extent should be small and
the next extent large or performance is affected and temporary tables are
too large. That is opposite of what I have done in the past. Any insights
on this?
Second question, is the ALTER FRAGMENT .... below only for tables initially
set up fragmented?
Thanks!
Tina McAllister
Data Base Adminstrator
tina-mcallister@atc.sears.com
512-248-4837
-----Original Message-----
From: Art S. Kagel [ mailto:kagel@bloomberg.net <mailto:kagel@bloomberg.net>
]
Sent: Monday, December 27, 1999 8:22 AM
To: informix-list@iiug.org
Subject: Re: number of extents
In general the fastest way to defrag a table is with:
ALTER FRAGMENT ON TABLE <tabname>
INIT IN <dbspacename or fragmentation clause>;
You can name the same dbspace the table already resides in and if you ALTER
the NEXT SIZE first you should get only one or two fragments afterward if
there is sufficient contiguous space available.
Art S. Kagel