RE: alter index to cluster

Posted in 1999

Rock, Howard — Tue, 3 Aug 1999 13:05:27 -0400 — source: Informix-list mailing list archive (1991-1998)

---------- From: Top Cat [SMTP:cstefanick@ocsmgmt.com] Sent: Tuesday, August 03, 1999 9:19 AM To: informix-list@iiug.org Subject: alter index to cluster I had a table which had 22 extents. I altered the unique index to cluster through isql. Now, oncheck -pT reports that the table has 20 extents. Shouldn't it be just 1? When I do a dbschema on the table the index is listed as 'unique cluster index,' so why are there 20 extents? There might not be enough contiguous space for just 1 extent. If you cluster an index there needs to be enough contiguous space for the entire table for the table to be truly de-fragmented